Using DAX Queries from Power BI within Power Automate

Matt Thacker

Hi all,

I know a lot of people are using Power Automate and Power BI, but I was messing around with them this weekend and came across a pretty cool use case. You can execute DAX queries on a Power BI dataset that's within your Power BI tenant, and use those results within a Power Automate flow.

One huge benefit of this is that it can replace the need for individual Lists to produce all of our filtered lists. And, more importantly, because it can use your entire data model, you can produce much more complex queries; especially if you have data tables outside of NXT that are related to your NXT tables somehow.

Below, I've included a link to my Notion page with a made a super simple step-by-step example.

Heather McLean

@Matt Thacker - care to share this today?

Matt Thacker

@Heather McLean Absolutely!