Privicy Error when refreshing files with combining tables: Error -2147467259

Hi, danielpcamara 

Are your data sources all from SharePoint excel? What's your data source?

Try to set the data source to public in SharePoint. Not the setting when connecting in powerbi.

According to the error message, it is judged that the data of the data source cannot be obtained on the service after you perform the combination operation. Do you have any complicated operations in PQ? It may need to modify your steps in PQ.

Reference:

Solved: Unable to Combine Data Refresh Error - Microsoft Power BI Community

Solved: Refresh failing (Combine Data) - Microsoft Power BI Community

Solved: Refresh problem - Unable to combine data - Microsoft Power BI Community

Solved: Unable to combine data - one server with multiple ... - Microsoft Power BI Community

Please upgrade the gateway to the latest. Try to public the file again.

Can the data source be connected to the gateway normally? Can you share the connection settings in gateway and settings in the dataset in the service? Refresh history?

Please hide privacy and change your browser language to English for my understanding.Thank you.

Best Regards,
Community Support Team _ Janey

Hi, danielpcamara 

Did the last scenario work? Is your problem solved? 

You didn't show all your queries, I can't analyze it well.

For the solution to the above thread, I can explain that he merged the custom query into a main query, and the refresh was successful. This may be because the service doesn't support the refresh of custom functions in some cases. Your problem should also be this, not your code error.

Like this:

Best Regards,
Community Support Team _ Janey

Hi, v-janeyg-msft.

Just to be more clear, this solve the problem: