Error Refresh in PB Service due to merge tables

[Jacekk111]

Hi PBi Community,

I have problem with refreshing error in service and I didn't find the answer how to solve it.

I created in desktop version a table merging 2 tables in power query from 2 different SQL sources.

The desktop refresh working correctly. However, after uploading on service I get the error refresh. I investigated the reason is merging 2 tables. Has anybody met with this type of error and know how to manage?

It seeems to be a problem with new version of PBI.... 

[Jacekk111 · Accepted solution]

I find solution from Yingjie Li. This is all about Privacy level. It must the on organizational level in desktop version as well as in gateway.

https://community.powerbi.com/t5/Service/Problems-refreshing-files-with-combining-tables/m-p/1051616