Datamart Login Fails Power Automate

[SolutionsWith]

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?

[SolutionsWith]

Please vote for this idea here
https://ideas.powerbi.com/ideas/idea/?ideaid=6ebc8d87-4017-ed11-b5cf-281878deb618 

[Siwei]

+1

[GilbertQ · Accepted solution]

Hi @SolutionsWith 

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