Small and medium business | Business Central, N...

Error Missing column “DEPARTMENT” Manufacturing Power BI app Business Central Cloud version 27

(7) Share

Report

Posted on by El Mehdi Taher

111

Hello everyone,

I’m trying to connect the Manufacturing Power BI app for Business Central version 27.0 to my Business Central Cloud (v27) environment, but I’m getting the following error message:

Something went wrong

Data source error: The ‘<oii>DEPARTMENT</oii>’ column does not exist in the rowset.

Cluster URI: WABI

Time: 2025-10-08 09:15:20Z

Here’s a screenshot of the error message:

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Pallavi Phade 5,420 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Namaste @El Mehdi Taher

There is no standard Column as "Deparment"in Manufacturing Tables . Seems some custom field is created . Check internally .

Can you verify any Dimension is configured wrt Department

Check General Ledger Setup configurations for Dimensions

If this helped , Please mark as "Verified"

Regards

Pallavi Phade

Was this reply helpful? Yes No
Suggested answer

Rishabh Kanaskar 6,219 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

The error means the Power BI app expects a Department column that doesn’t exist in your Business Central dataset.
Try:

> Enable the Department dimension in Business Central and assign it to manufacturing entries.
> Or edit the Power BI template in Power BI Desktop to remove or replace the missing column.

There’s no Business Central setting to auto-add this column. You must either adjust the template or include the dimension.

Thanks

Rishabh

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,090 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, Looks like it's related to the new features below.

What's new: Drill-back and dynamic dimension name support in Power BI apps for Business Central

You can submit this question to the BC yammer group, where Microsoft technicians will be able to give you better suggestions.

Viva Engage : Dynamics 365 Business Central Partner Community (Formerly: Development) : Power Platform and Dataverse : New Conversations

Thanks

ZHU

Was this reply helpful? Yes No