Forum Discussion
Power BI Online - Missing credentials for dataset on Azure SQL DB Managed Instance
Hi Anonymous,
for a connection to Azure SQL DB to use Basic authentication you need to add it to the (Enterprise, or now Standard) Gateway. That's also how we set it up. After that you can select the gateway in the settings of the dataset and it works fine.
If you want to read more about the setup, we used the approach of Securing the connection between Power BI and Azure SQL Database, with the gateway installed in the same VNet as mentioned in this article.
Super UserHi Anonymous ,
The Owner of the dataset should be able to modify the credentials. Since it is grayed out, that indicates that you do not have permissions. Also, when you look at the "refresh history" is that where you are getting the data credentials message or is there a different one in there?
Hi collinq,
Thank you for your reply. I have checked my account, and am on the same account as is listed under 'This dataset is configure by ...', so I am on the owner account. I also checked the dataset settings again, and when I wait long enough, a few minutes, the data source credentials become clickable and I get a link to edit credentials.
However, now I get the same problem as I saw in my personal workspace. I get the option to sign in as 'Basic' or 'OAuth2', neither of which work with the database credentials I needed to sign in to the database on the Azure SQL Database Managed Instance. I get the following error:
It appears as if a connection cannot be made to the server, but it recognizes the source is in the cloud and a gateway is not needed, so I\m not sure why this would be.