Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I have two reports in Power BI Service based on one dataset (sql tables imported via PBI Gateway from on-premises database). The first report has been initialy created in PBI Desktop then uploaded to Service - this created a dataset with the same name as report. Then one of my users created a copy of the report in PBI Service.
One of my tables in the first report had a filter in Power Query limiting the rows fetched from database. If I change the filter now (opening the report in Desktop and then publishing it again to Service) the 2nd report working on the same dataset cannot see the new records in database. Is it normal? What can I do now ?
Ryszard.
Hi Ryszard,
If you filter the data in the Query Editor, you filter the whole dataset. That's why the second report is affected after republishing the dataset. You can filter data with a slicer or a report filter.
Best Regards!
Dale
You're right, it should be afected by query filter, but is not. I mean, when I change the filter in query so, that new records should be available, they are ony available in the main report, not the 2nd one.
Hi @rylach,
According to my test, the second report will be updated automatically.
Did you apply any other filters?
Can you try to create a new table as same as the second table? Then check out what will happen.
Best Regards!
Dale
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.