Definition of data query in report based on shared dataset

[rylach]

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.

[v-jiascu-msft]

@rylach,

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

[rylach]

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.

[v-jiascu-msft]

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