There was a data source access error in Power BI Service

[Anonymous]

Hi, hope you could help or explain.

There is a report using Direct Query to SQL server and on the desktop it is
fine and refreshes successfully. When we publish it to service unable to see any visuals.
We tried to map to the Gateway as well as not to. Still same issue. Any ideas ?

[Anonymous · Accepted solution]

Hi @Anonymous ,

Sorry for my late reply...

Since the refresh operation could be implemented in the Desktop, it means that there is no problem with the data source itself.

In my opinion, the high probability is that the gateway configuration is incorrect. You could follow these steps for trouble shooting:

1.Please restart the Gateway(enterprise version) firstly to make sure the gateway is online and you could use it.

2.Ensure that each data source has been configured gateway.

3.Perhaps the server/ database name or the credentials has been changed ,so re-enter the basic information in Date Source Setting (pay attention to the Authentication Method)

You could take a look at this blog for detailed information.

Did I answer your question ? Please mark my reply as solution. Thank you very much.

If not, please upload some insensitive data samples and expected output.

Best Regards,

Eyelyn Qin

[Anonymous]

@Anonymous , thank you.

We sorted it out. Appears that the select was pretty complex and included couple of diffrent DB's. So by fact it was single query but gateway was confused since there was 2 data sources. We switched it to a single view and now it is working fine.