How to execute a DAX Query from Microsoft Power Automate against SSAS?

Question

I have a SSAS Tabular instance in a server, and I want to use Microsoft Power Automate to shoot an email notification to me when the data shows a specific trend.

How can I execute an EVALUATE DAX query from Power Automate against my SSAS Tabular instance, so it can return the aggregate table I need right into Power Automate?

I could not find a built-in connector that explicitly allows to execute this DAX Query. Is there any connector I can use for this? Like an OLE DB or OData? (I'm not a savvy on any of these two).

The goal is to execute the DAX Query to receive a small aggregated table from SSAS, which I will use to iterate through its rows and shoot an email notification if one of the fields is below a certain threshold.

Answer 1

If you can use live connect and connect to Powerbi and create a table or matrix visual , you will be able to get the email notification based on the trend in the data. Power Automate has connectors to Powerbi . Just give it a try .