gateway refresh failures of data joined from two different datasources.

[satyabrata]

Hi,

i  am facing this issue as an organisation:
i have two tables of data coming from sql and sharepoint excel file. i have to join these tables in powerquery.

when i refresh this report on desktop, refreshes are fine, but when i refresh this report using gateway on service then refresh fails.

it is not only with sharepoint and sql, but sql and blob containers aswell.
so i am not sure why gateway is not allowing two datasources to join.
my gateway credentials are ok and individual reports from single datasources are also refreshing using gateway.
any body feels this pain aswell?

[GilbertQ]

Hi @satyabrata 

Can you please make sure on your data source settings you set the Privacy Level to none for all of them.

Also if you have an error if you can please post the actual error to help troubleshoot?