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.

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

PANNEER,
Remove ID field from filter section and pull the ID you want into the section. Since this is a report-level (filters on all pages) filter, one-time change should do it.

 

 

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!

Proud To Be a Super User !!!
LinkedIn