Data Refresh issue

[DanielOtero]

Hello,

I have a powerbi desktop file that includes multiple SQL queries to different servers, and all executes/refreshes fine, but when I publish to PowerBI.com, it will not refresh and I get the following error. Since it is flagged as a privacy error, I have ensured my privacy settings in both the desktop (set to ignore) and the the pbi.com gateway (privacy level set to "None") are good. But I'm still getting this error. Any thoughts why?

[V-lianl-msft]

Hi @DanielOtero ,

The error prompted that you cannot combine an external data source within another query. To deal with the problem, strip the “external” data source and put it in it’s own query.

See if it will help:https://www.excelguru.ca/blog/2015/03/11/power-query-errors-please-rebuild-this-data-combination/ 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[otravers]

Your privacy Power BI Desktop don't translate to the service. You'll want to restructure your nested queries, as explained here:

https://blog.crossjoin.co.uk/2020/06/21/video-power-bi-data-privacy-settings-deep-dive/