Forum Discussion
DirectQuery reports not loading in PowerBI service
Hello all,
Recently we installed an on-premises gateway with the aim of sharing reports that are based on data stored in SQL server. However, when using DirectQuery we get the following error message:
Logging into Sql server failed. Possible reasons for this error include an invalid authentication mode, a missing login in Sql server, etc.
In the data source settings of the gateway, the credentials for the basic authentication method are provided. It indicates that the connection is successful, and the gateway status in the dataset settings also looks fine.
This problem does not occur when the data connectivity mode is set to 'import', it only happens with DirectQuery. What is going wrong here?
Please let me know if you have any ideas!
10 Replies
- Hi there
When you configured the data source did you enabled SSO (Single Sign On) which would then want to pass through the individual users to the database. Hi fabbimk ,
You could use IP address as the server name and check if it works.
If it works, you may check DNS settings. Here is the document for your reference:
Thanks for the replies!
Did some more research but our SQL server is on Amazon RDS. Is DirectQuery even a possibility then?
- Hi there
I am not 100% sure, it would appear that it has to be a SQL Server source.
Can you configure it as a data source in the Gateway on the Power BI Service?It is currently configured with SQL server as data source type, which works when the data in the report is loaded in Import Mode. There is no separate option for Amazon RDS, only for AWS Redshift.
I've found an open idea here that would probably cover what we want to achieve, seems to be a topic since 2014.
