SQL Server & Direct Query - This report couldn't access the data source

[Anonymous]

Yesterday I was updating some of our existing DirectQuery reports and all of a sudden we are getting a new error. This report works fine in Desktop, it's only on the web service that I am getting this error. 

From what I can tell, the data sources are mapped to the gateway correctly. Our gateway and the data sources that are a part of it succeed the test connection. Additionally, the reports I have using Import rather than DirectQuery are able to refresh fine with the same gateway/data sources.

Things I have tried:

1) Updating gateway. Updating our gateway broke it, so we built an entirely new one and re-connected the data sources. Note: This connection uses Windows rather than Basic authentication. 

2) Creating entirely new reports from scratch to ensure that the server information added on Desktop match the server information on the Web service. Sometimes with new reports I can get visuals to show up, but they stop working after inconsistent updates (e.g., one time I had a report working and then I changed the theme and re-published it and the visuals couldn't connect anymore).

[v-lionel-msft]

Hi @Anonymous ,

Does your report contain RLS?
What is your role in the workspace?

Can you use the dataset to create new reports in Service?

Can your report be refreshed locally?

There may be a problem with the data source, or a problem with the connection, or a problem with the access permission.

However, if it can be accessed locally, it is more likely to be a problem of connection or access permission.

Or does your data set have these limitations？

Limitations of DirectQuery 

Best regards,
Lionel Chen

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