Power bi data refresh is not sync to BC live data

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.