Forum Discussion
Power Automate Run Query Against a Dataset Syntax?
Hi Anonymous
Where did you execute this query? Table.SelectRows is a Power Query function which should be used in Power Query Editor or Dataflows in the service. The language used in Power Query is called M language. While EVALUATE is often used to evaluate a DAX expression. DAX is a totally different language from M.
If you want to execute a DAX query against a Power BI dataset and export data to a file, you can refer to Curbal's videos as below:
Export from Power BI to Excel up to 🔥100k rows 🔥| Run a query against a dataset
Automatic exports of Power BI data 🤖 | Run a query against a dataset
If you want to use Power Automate to export data without executing a query, you can refer to the following videos:
Power BI export to excel and csv with Power Automate
How to Export filtered data to Excel from Power BI button using Power Automate?
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Community SupportHi Anonymous
Where did you execute this query? Table.SelectRows is a Power Query function which should be used in Power Query Editor or Dataflows in the service. The language used in Power Query is called M language. While EVALUATE is often used to evaluate a DAX expression. DAX is a totally different language from M.
If you want to execute a DAX query against a Power BI dataset and export data to a file, you can refer to Curbal's videos as below:
Export from Power BI to Excel up to 🔥100k rows 🔥| Run a query against a dataset
Automatic exports of Power BI data 🤖 | Run a query against a dataset
If you want to use Power Automate to export data without executing a query, you can refer to the following videos:
Power BI export to excel and csv with Power Automate
How to Export filtered data to Excel from Power BI button using Power Automate?
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Thank you very much for your reply! I realized after doing a bit more reading that Power Automate was looking for DAX and not M. I had tried some DAX previously, but I was unfamiliar with the EVALUATE command and none of my DAX attempts included an EVALUATE command.
I know this post is getting old now but I stumbled across it looking for the same thing.
To quickly and easily generate a dataset query, you can do it from inside Power Bi and copy/paste it into Power Automate, or wherever.1. In Power BI click on "View" > "Performance Analyzer"
2. Click "Start recording"
3. Refresh your data by clicking "Refresh"
4. Click "Stop recording"
5. You will then have a representation of your data (mine was in a table), so click the "+" next to it then click "Copy query" and paste it wherever you need it. Very fast and most importantly - accurate!
Hi Anonymous, I'm trying to do something similar. Would you mind posting your code below to give me some guidance?
Thank you!
Here is what I ended up using:
EVALUATE FILTER('Staffing Request', [DAX_Check_Firm_Offer_Due]="Firm Offer Overdue")
