Announcements
Hi
Have a Power BI report that pulls data from various reports in Sharepoint. I have existing flows that grab reports from a mailbox and overwrite them daily.
What I would like to do is pull a snapshot of the data table in Power BI that has computed DAX and M calculated columns. Is there a way to do this with Power Automate?EDIT: This guide was really good for the overall process https://www.youtube.com/watch?v=wy1BE1TJ_jc
This guide was really good for renaming columns https://www.youtube.com/watch?v=lWu4n-ODe4U
yes, there is a standard "Run a query against a Power BI Semantic Model" action. You can "borrow" the DAX for the query from the Power BI visual that has the same data.
Note that M (Power Query) is not part of this.
Thank you so much. I've found 'Run a query against a dataset' but not 'Run a query against a Power BI semantic model' not sure what I am doing wrong?
"Semantic Model" is the new cool (...) name for "dataset". Same difference.
Thanks so much for the quick reply (and your reply on the Fabric forums also). Can see a few tutorials on YT, so making my way through them now.
A couple more questions
1. Assuming it's easily doable to add a custom column based on filename.
2. Is there a way to amend the column name in the flow to retain the original column name as the table I'm exporting? I've got a flow working well, creating a CSV in sharepoint with the columns from the table (using DAX query) but the column names have the format of 'TableName[ColumnName]' when I am preferring to have the original column names so I can re-purpose a copy of my existing dashboard rather than re-add the columns one by one to each slicer and table - hope that makes sense.
Change your DAX with SELECTCOLUMNS and/or use a Select action to rename columns.
I grabbed the query using the Performance Analyser trick, but the query doesn't contain SELECTCOLUMNS. I have a large volume of columns so the select action wouldn't be practical for my case. Was hoping there was a 'bulk' way of approaching this.
If you only want to remove the table name you can split the strings by [ and ].
Can you give me a short example? Not sure what you mean sorry. Still a novice.
post a sample raw output of the query step
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
In our never-ending quest to improve we are simplifying the forum hierarchy…
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
trice602 237 Super User 2026 Season 1
David_MA 176 Super User 2026 Season 1
Power Platform 1919 96 Super User 2026 Season 1
