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

(5) Share

Report

Posted on by El Mehdi Taher

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 (1)

Answers (0)

Suggested answer

Pallavi Phade 2,017 on at

Like (1)

Report

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

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