
Announcements
Hello,
I was tasked to read a power bi dataset with power automate but the options under the power bi action that I can use are maybe "run a query against a dataset" but I dont run the administrator part of it so not sure where to get the query. So I noticed that PowerBI online view sends a report with an excel file attached every mooring to my email. So I made an Power Automate job to save the excel file to my onedrive. My next step was to have power automate get the results but the Excel actions need to name a "table" but my excel spreadsheet does not have a table. Keep in mind, I need to download it to my one drive daily to get updated results. How can I go about either reading straight from the Power BI or Parse the excel data with no table and use it?
not sure where to get the query
In the Power BI report find a visual that has what you need (personalize it if possible). Click the ellipsis (...) then Export then "Excel with live connection". Once in Excel, grab the DAX query , modify as needed, and then plug that query into the "Run a query against a dataset" action.