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
  • v-sshirivolu's avatar
    v-sshirivolu
    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.

PANNEER's avatar
PANNEER
Frequent Visitor
8 months ago

I couldn't see the broken ID field from all pages in filters.

  • rohit1991's avatar
    rohit1991
    Super User
    8 months ago

    Hii PANNEER 

     

    You won’t always see the broken ID field in the Filters pane because it can be orphaned in the report metadata. Try this:

    1. Open the report in Power BI Desktop.

    2. Go to View >> Selection pane and View >> Bookmarks >> check if any bookmark or hidden visual is still using the old ID field and remove it.

    3. In Model view, confirm the ID column truly exists (or re-add it with the same name if required).

    4. Clear filters by temporarily duplicating the page, then delete the original page (this removes hidden page/report-level filters).

    5. Save and republish to the same workspace.

    6. In Dynamics 365, remove the embedded Power BI report and add it again to refresh cached filter metadata.

    This usually fixes cases where the filter exists in cache but not visibly in the report UI.