Getting PowerBI Dataset or Parsing Excel Spreadsheet

(0) Share

Report

Posted on by btava001

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?

Categories:

General topics

I have the same question (0)

All responses (1)

Answers (0)

lbendlin 8,624 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No