Unanswered

How to Connect to Dataverse using Power Automate Desktop SQL Connect

(0) Share

Report

Posted on by vivek0307

I am trying to connect to Data verse using PAD SQL Connect. I am getting an error (see the below Image). I don't want to go with API approach, Can someone guide me how to do the configuration and connection to Data verse using SQL Connect.

Please note - I am able to access Data verse using SSMS. Tried the same way in PAD (as shown in the below image) but failed using exactly the same userID, Password and Authentication Type.

Thank you in Advance

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (0)

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (1)

Report

Hi @vivek0307

Not sure, may be some approval is needed for this ?

@Agnius do you have any thoughts ?

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (2)

Report

It seems like PAD is not allowed to do this by default. Not sure if the approval is something that you can grant via your Azure AD admin center, or it is something that MS handles (the error is a bit vague on that). I suggest trying to get help from MS support to see what they say about this.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No
vivek0307 6 on at

Like (1)

Report

Thank you @Nived_Nambiar & @Agnius for your response. I will try to raise Microsoft ticket and see what they think on this. I will keep you guys posted on this thread.

Was this reply helpful? Yes No