Forum Discussion
DirectQuery Azure SQL DB Data Source Credentials is DISABLED
I have 2 PBI reports in using Desktop, connecting to Azure SQL DB 1. ImportQuery - Azure SQL DB 2. DirectQuery - Azure SQL DB I got Power BI Pro account, I've published the 2 reports, they both...
The data source credential is disabled, even after refresh report.
But for ImportQuery - data source credentail is enabled.
Hi , Anonymous
You can refer to this article Azure SQL Database with DirectQuery
The following two points are important：
- Specify the fully qualified server name when connecting .
- Ensure firewall rules for the database are configured to Allow access to Azure services
If you make sure that servername and firewall are fine and the problem is still unresolved, I suggest you to open a ticket here for help if you are a pro user.
URL: https://powerbi.microsoft.com/en-us/support/
Best Regards,
Community Support Team _ Eason