Forum Discussion

SolutionsWith's avatar
SolutionsWith
Frequent Visitor
4 years ago
Solved

Datamart Login Fails Power Automate

Hello, im trying to create a power automate flow that query's my datamart.

 

I can connect into the datamart fine with SSMS and query the tables

 

However, when i try connect with either SQL or AZ SQL connectors in flow, I get a login failed back from the datamart.

I am using the same AZAD auth in the flows like in the SSMS, but get back this error:


Any idea's on what might be the issue? Or where to start looking?

 

 

3 Replies