Data Credentials in PowerBI Service - The credentials provided for the SQL source are invalid

[SRobbo1990]

Hi all, 

I've seen this be a problem for several over the years but I can't seem to find a 'proper' solution.

I have a pbip file that is pulling data from a Synapse DB as the only data source. Previously my colleague had set up the Semantic Model and it was refreshing with no issue, I have needed to take the model over but unfortunately I now get the above error message when trying to update the credentials. My admin account has all relevant permissions to connect to the DB in SSMS and it allows me to refresh the data in Power BI desktop. However as soon as I publish the model to Service I get the following;

On trying to use my admin account to update the credentials I get this;

I am using Oauth2 in both Desktop and Service with organisational privacy level. I have also got rid of all global permissions in the desktop file. What's more annoying is I've left the UAT version of the model in the previous owners name and all appears to be refreshing and working. 

What am I missing? Any help greatly appreciated

Thanks

[uzuntasgokberk]

Hello @SRobbo1990 ,

I prefer this way to solve correctly and tests. First of all, open pbı desktop and connect synapse db. Check it your crediantial is true or not. Assume that your credials is true and then check the semantic model in PBI Service. Go to settings and check it gateways. İf gateway connection is selected onpremise or shreable cloud. Find it on the settings of "Manage connection of settings" and find the connection and use your correct creadiantial.

Best Regards,
Gökberk Uzuntaş

LinkedIn: https://www.linkedin.com/in/g%C3%B6kberk-uzunta%C5%9F-b43906198/

Medium: https://medium.com/@uzuntasgokberk

İf this post helps, then please consider Accept it as solution and kudos to help the other members find it more quickly.

[SRobbo1990]

Hi Gökberk,

Yep tried all of the above and on the gateways and connections page get the following;

I even ran a test with a brand new semantic model using the same Syanpse DB and bringing down one table and it is doing the same for me

[uzuntasgokberk]

Hello @SRobbo1990 ,

That means your crediantial is not correct. You need to use correct crediantial.

Best Regards,
Gökberk Uzuntaş

LinkedIn: https://www.linkedin.com/in/g%C3%B6kberk-uzunta%C5%9F-b43906198/

Medium: https://medium.com/@uzuntasgokberk

İf this post helps, then please consider Accept it as solution and kudos to help the other members find it more quickly.