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.
Most Valuable ProfessionalHi 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.
Thanks nickyvv!
I've added it to our gateway and now the dataset can be refreshed, it is solved! I was trown off by the part 'You don't need a gateway for this dataset, because all of its data sources are in the cloud' under the gateway settings of the dataset. Next to that, it took very long to load our gateways on this screen. Because of that I thought I couldn't add a gateway, but when I waited it was possible and I've done as you suggested.
Thanks!
- nickyvv
Great to hear Anonymous, glad you got it solved!