Forum Discussion
Credentials greyed out - SQL Server Exposed to the Internet
Hi pey1,
We are grateful for your participation in the Microsoft Fabric Community forum.
Since Power BI Service doesn't let you set credentials directly for a non-cloud SQL Server, it needs a gateway for scheduled refreshes. Here's the best way to set that up:- Install one On-premises Data Gateway per client tenant, each on a separate VM or machine (can be lightweight cloud or client-hosted).
- Point each gateway to your central SQL Server (just make sure it’s locked down with IP allow-listing and SSL).
- In each tenant’s Power BI Service, register the gateway, set up the data source, and plug in the right credentials for that client’s database.
- Use SQL logins or database permissions to make sure clients can only access their own data.
- You can’t install more than one gateway on the same machine anymore (Microsoft blocked that), so each tenant needs their own box or VM.
Credential Option Is Greyed Out - Once you publish your dataset, Power BI sees that your SQL Server isn’t a cloud-native source, so it disables the credential box. At that point, only a gateway can handle auth and refresh.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Thanks.
Hi pey1,
We are grateful for your participation in the Microsoft Fabric Community forum.
Since Power BI Service doesn't let you set credentials directly for a non-cloud SQL Server, it needs a gateway for scheduled refreshes. Here's the best way to set that up:
- Install one On-premises Data Gateway per client tenant, each on a separate VM or machine (can be lightweight cloud or client-hosted).
- Point each gateway to your central SQL Server (just make sure it’s locked down with IP allow-listing and SSL).
- In each tenant’s Power BI Service, register the gateway, set up the data source, and plug in the right credentials for that client’s database.
- Use SQL logins or database permissions to make sure clients can only access their own data.
- You can’t install more than one gateway on the same machine anymore (Microsoft blocked that), so each tenant needs their own box or VM.
Credential Option Is Greyed Out - Once you publish your dataset, Power BI sees that your SQL Server isn’t a cloud-native source, so it disables the credential box. At that point, only a gateway can handle auth and refresh.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Thanks.
Thanks - this seems to be the only solution although its a very poor solution. Can you believe that this is not possible! I am shocked that you cant use MS SQL on a VM with mutlpiple tenant semantic models!
I would further go to say that if Microsoft just "fooled" Power BI Service into thinking it was a cloud based SQL Azure connector and allowed credentials to be entered - this would be a solution too! Or all you to use a Cloud connection from the Manage gateways area to be signed as a Cloud connector. Very poor as its one small thing that stops a refresh - everything else that is expensive to set up is all for naught!