Forum Discussion
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?
As far as I am aware currently datamarts are in preview and not supported to connect from Power Automate to datamarts.
You can vote for the idea at https://ideas.powerbi.com
3 Replies
- GilbertQSuper User
As far as I am aware currently datamarts are in preview and not supported to connect from Power Automate to datamarts.
You can vote for the idea at https://ideas.powerbi.com
- AnonymousNot applicable
+1
- SolutionsWithFrequent Visitor
Please vote for this idea here
https://ideas.powerbi.com/ideas/idea/?ideaid=6ebc8d87-4017-ed11-b5cf-281878deb618