Azure sql connction error

[neees78]

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. 

[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/

[neees78]

sorry for this (many questions) :)...but I use gateway for other sources but this one is cloud-based , thought we don't need a gateway ? is it possible to  connect via gateway ?  

[tackytechtom · Accepted solution]

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 🙂

[neees78]

@tackytechtom  thanks for your help ,,, its working today , via on premises gateway 

configure few settings on connection and its refreshing perfectly now 

PBI service was not whitelisted on that SQL server , thus it worked on desktop but not once published 

[tackytechtom]

Hi @neees78 ,

Have you tried refreshing the credentials in the service, yet? 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[neees78]

Hi, 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