Extra filter showing up

Question

Hi,I am working on a report that uses a matrix. The report has several filters. I publish the report and view in the Power BI web with no issues. I then embed the report on a Workspace in Dynamics 365. The report works fine except for this extra ID filter that shows up in Dynamics. You can't actually select the filter and it has an error icon.Any thougts as to what is going on here.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Thanks,&nbsp;Richard

datainsights · Answer

richardksm,&nbsp;try opening the report in Power BI Desktop and remove the ID filter.

richardksm · Answer

What's odd is that the filter does not exist when I open it in Power BI desktop.

datainsights · Answer

richardksm, try removing the report from the workspace and republish it.

richardksm · Answer

Thanks for the suggestion. I just tried this and no luck.

datainsights · Answer

richardksm, check out this link:&nbsp;https://crmchartguy.com/2019/03/24/embed-filtered-power-bi-reports-on-dynamics-365-forms-again-the-official-way/&nbsp;&nbsp;Also, try hovering over the column name in the filter so you can see what table contains the ID column. This might assist in troubleshooting.

Forum Discussion

Extra filter showing up

6 Replies

Related content

Extra Month Showing Up

Data Factory adding extra \ in JSON data

Matrix visual shows extra blank rows (abnormal)

Notebook extra blank pane

DAX expression ignoring blanks statement when extra filter is added