Forum Discussion

SRobbo1990's avatar
SRobbo1990
Frequent Visitor
1 year ago

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

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...
General Comment
Need Help
uzuntasgokberk's avatar
uzuntasgokberk
Super User
1 year ago

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.

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |

SRobbo1990's avatar
SRobbo1990
Frequent Visitor
1 year ago

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's avatar
    uzuntasgokberk
    Super User
    1 year ago

    Hello SRobbo1990 ,

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

    Kind Regards,
    Gökberk Uzuntaş

    📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

    🔗 Stay Connected:
    📘 Medium |
    📺 YouTube |
    💼 LinkedIn |
    📷 Instagram |
    🐦 X |
    👽 Reddit |
    🌐 Website |
    🎵 TikTok |