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?

Report
All responses (
Answers (