Forum Discussion
Report couldn't access data source in Direct Query mode
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?
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?
I tried both, with the same result. any other suggestions?
Anonymous Are you using the datasource on the gateway for other reports, or is this the first one you are trying to hook up? Has the SQL Server been configured to allow external access?
No this is the first one. Can you give me a hint on how to do this? Or Check it?
DirectQuery access via service is handled different than connecting via powerbi desktop?
Is this the correct setting in sql server (2016)