Forum Discussion
Helper IIAzure sql connction error
I've pbi report connected to Azure sql instance (using different login details) than my windows login
When at desktop....report refresh fine ..no problem
once it's published ..., a data source credential error occurs,
This SQL instance don't need a gateway to be installed
its cloud based but I suspect because I'm using different credintals to connect to it ..is the issue
I publish reports using my normal user account
at desktop I establish connection using Microsoft account option and then I use specific DB user name ....etc.
You are right, the database is in the cloud, but as you can see the database is not generally available to the public. So you need to provide Power BI a way to get into the network / retrieve a IP-address that is allowed by the database for access. A gateway will help you do this 🙂
8 Replies
- tackytechtom
Most Valuable Professional
Hi neees78 ,
Have you tried refreshing the credentials in the service, yet? 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
neees78Hi, tried a few times ....selecting all possible options (always failing)
guess because I connect to SQL db using a different account than my PBI service
Should the authentication be Database user name and password on desktop and PBI service
- tackytechtom
Hm... You should be able to use your credentials in Power BI. Could it be that your IP is whitelisted in the Azure SQL Database which is why you are able to connect from PBI Desktop, but not the service?
- neees78
ok ..you are correct 🙂 our office IP (statcis) was whitelisted by the DB provider
What I should ask them to do to get my report to refresh on the service
- tackytechtom
Well awesome. I'd recommend to use a gateway 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/