Power bi data refresh is not sync to BC live data

[Shineccx007]

Hello everyone,

I have created a power bi report with the semetic model connected with the Dynamic 365 BC premium system. I built the model with table item card and the warehouse entires, linked by item code one to many relationship. My item card, item category code is selected but for some reason some items' catogory code is not captured there. Did anyone got the same issue as me?

Thanks!

S

[v-sgandrathi]

Hi @Shineccx007,

Thank you for engaging with the Microsoft Fabric Community Forum

Refresh the Dataset:
In Power BI Desktop or Power BI Service, manually refresh the dataset to ensure you have the latest data from BC.
If you use the Service, make sure a scheduled refresh is set up and completes without errors.
Validate Data Model Relationships:
Check that Item Card[Item Code] is linked one-to-many with Warehouse Entries[Item Code].
Review data integrity are there Warehouse Entries with Item Codes missing from the Item Card?
Check for Blanks in Business Central:
Look at the Item Card table in Business Central and confirm all items have an Item Category Code filled in.
Sometimes data may be missing in BC, which is not related to Power BI.
Don’t Rely Only on Visual Filters:
If you use Item Category Code in visuals with filters or slicers, it can unintentionally leave out some items.

Regards,
Sahasra.

[Shineccx007]

Hi Sahasra,

I did checked all the steps above and the item category code is still not sync to what my system has defined.

S

[v-sgandrathi · Accepted solution]

Hi @Shineccx007,

Thank you for your follow-up.

Since the dataset is refreshing correctly and the relationships between Item Card[Item Code] and Warehouse Entries[Item Code] are properly set, but the Item Category Code is still not displaying as expected, there are several additional steps to consider. Please verify that the Item Category Code field is included in the web service or OData feed published from Business Central, as it must be part of the exposed page or query to be accessible in Power BI.
Also, check the direction of the relationship between tables, as a single-directional link might prevent the category from flowing correctly. In Power Query Editor, review all transformation steps to ensure no columns or records are being inadvertently filtered out. You may also test by creating a simple table visual with just Item Code and Item Category Code, or by adding a calculated column such as Item Category Debug = SELECTEDVALUE('Item Card'[Item Category Code]) to confirm the values are present after import. If the issue persists, try importing only the Item Card data into a new report to help determine whether the problem originates at the source, during transformation, or within the report visuals.

Thank you.

[v-sgandrathi]

Hi @Shineccx007,

We wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.

Thank you.

[v-sgandrathi]

Hi @Shineccx007,

As we did not get a response, may I know if the above reply could clarify your issue, or could you please help confirm if we may help you with anything else?

Thank you.

[v-sgandrathi]

Hi @Shineccx007,

Hi ,
we haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.

Thank you.

[lbendlin]

Semantic model refreshes (ie import mode) and real time data (ie live connection/direct query mode)  are two different things.

What is the expected end user experience?

[Shineccx007]

The expected result is as long as my semantic dataset is schedule refreshed, the data should be up to date. But when I manual refresh the data under PBI desktop, the item card, item category is still missing in the dashboard. And I don't know why.