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?
Hi All,
Recently I installed On-premises data gateway (Standard Mode) on one of the Server Machine and configured it.
When I try to open a report has a direct query on Power BI Web, I was getting error message
"This repoer couldn't access the data source because it doesn't have permission. Choose another data gateway, or contact the gateway administrator"
To Solve this, I followed following steps:
- Connect to Power BI Service
- Settings--> Manage gateways and you will see your configured gateway
- Find the Data Source configured under this gateway and having an issue
- Double click on Data Source and you will see Data Source Settings
- At the end, there is an option "Advance settings". Expand this and uncheck option--> "Use SSO via kerberos for direct queries". Default It is checked. It says "This will only be applied for DirectQuery. Imports will use the Username and password specified in the source details Learn more: https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem#credentials"
- Click on Apply and It started working for me.
Hi All,
Recently I installed On-premises data gateway (Standard Mode) on one of the Server Machine and configured it.
When I try to open a report has a direct query on Power BI Web, I was getting error message
"This repoer couldn't access the data source because it doesn't have permission. Choose another data gateway, or contact the gateway administrator"
To Solve this, I followed following steps:
- Connect to Power BI Service
- Settings--> Manage gateways and you will see your configured gateway
- Find the Data Source configured under this gateway and having an issue
- Double click on Data Source and you will see Data Source Settings
- At the end, there is an option "Advance settings". Expand this and uncheck option--> "Use SSO via kerberos for direct queries". Default It is checked. It says "This will only be applied for DirectQuery. Imports will use the Username and password specified in the source details Learn more: https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem#credentials"
- Click on Apply and It started working for me.