Sending DAX query from Power BI to Power Automate

[ais_zhumabek]

Hello everyone!

I have to create a dashboard with exporting to xlsx functionality. Due to row limit (up to 1k) during exporting data from Power BI to Power Automate, I started using "Running against Dataset" with DAX query.

The problem is that when dashboard user applies some filters, I can not see all filtered values (due to row limit) and paste it into DAX query. So, can you solve these 2 moments:

a) See all distinct filtered values

b) Past it into DAX query in Power Automate?

Thank you for your attention and spent time

[v-xiaotang]

Hi  @ais_zhumabek 

>> See all distinct filtered values

Please check if this helps, Power Automate Get Unique Values from Array | Distinct Items from Excel, SharePoint & Dataverse - Yo...

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.