Refresh of Report after opening locally

[hs28]

Hi,
has anyone found a good solution/workaround for the following issue:
When I open on of my reports and they have a lot of tables, I cannot immediately refresh them locally.
I get the following error (This query refers to other queries or steps and therefore cannot access the data source directly. Create this data combination again):

Then I have to go inside Power Query and click through all the report relevant tables and wait until the preview refreshes. This can take up to 1 hour dependant of the report.
Thank you.

[Anonymous]

Hi @hs28 ,

The problem should be related to Formula.Firewall, please refer here:
Behind the scenes of the Data Privacy Firewall - Power Query | Microsoft Learn
blog.crossjoin.co.uk

If there are no privacy concerns with the particular data you're working with then the easiest solution is to ignore privacy levels entirely. This can be found under the options and settings as described here:

https://learn.microsoft.com/en-us/power-bi/enterprise/desktop-privacy-levels

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group