Forum Discussion
Report couldn't access data source in Direct Query mode
I've created a simple report with PBI desktop. In desktop all works fine. When I open the report in the service i get the following error: Report couldn't access the data source because it doesn...
Anonymous I would assume that the credentials can access the SQL Server, otherwise you wouldn't be able to use the datasource. My thought is that while it can reach the SQL Server, it can't access all the tables/views that it needs to in order to produce the report results... what level of permission does it have on the SQL Server? Is it a different account, or your credentials?
Alternatively, did you use a basic auth connection in the Desktop?
just go and uncheck 'SSO sign in via direct query with kubernetes' option in 'data sources' in 'manage gateways and connections' . if it doesn't work also uncheck 'skip test connection' and save.