Forum Discussion

PANNEER's avatar
PANNEER
Frequent Visitor
8 months ago
Solved

Error in filters

Hi friends, I created a report and published it to the Power BI Service, then integrated it into Dynamics 365. After integration, I’m getting an error on the ID field in filters across all pages sta...
Need Help
  • Anonymous's avatar
    Anonymous
    8 months ago

    Hi PANNEER ,
    Sometimes the broken field still exists in the Report/Page level Filters pane, even if it doesn't appear in any visual or bookmark, so it's worth checking and clearing filters there explicitly. This issue can happen not only when a column is deleted, but also when it's renamed or replaced, while downstream systems like Dynamics 365 continue to reference the old field name. In most cases this isn't a Power BI visual bug, but due to Dynamics 365 caching report metadata, which is why simply fixing and republishing the report may not be enough unless the embedded report is removed and added again. Also, follow order, clean the report in Power BI Desktop first, then republish, and only after that re embed it in Dynamics to ensure the cache refresh works correctly.

rohit1991's avatar
rohit1991
Icon for Super User rankSuper User
8 months ago

Hii PANNEER 

 

This error occurs because Dynamics 365 caches Power BI filter metadata. If a column (like ID) that was previously used as a page-level or report-level filter is later renamed, removed, or replaced in the Power BI model, D365 still tries to reference the old field, even though it no longer exists. To fix this, open the report in Power BI Desktop, remove the broken ID filter from all pages, add the correct field if required, republish the report to the same workspace, and then remove and re-add the embedded report in Dynamics 365 to refresh the cached schema.