Unanswered

How to get data from a read only power bi report

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hey,

I am trying to create a flow where I export data from a tile in a report to an Excel file. I find the actions where I can export the dashboard to a SharePoint location but I want to export just the data from a specific tile in a report where I have read-only access. I'm new to power apps so please go easy on me 🙂

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (0)

lbendlin 8,551 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
where I export data from a tile in a report to an Excel file.

Reports don't have tiles. They have visuals.

the actions where I can export the dashboard to a SharePoint location

Please elaborate. I am not familiar with that feature.

in a report where I have read-only access

Power BI reports are (sadly) by design read-only.

Assuming you mean a report visual - click on the visual's ellipsis (...) in the top right corner of the visual. Select Export. Summarized Data... Excel with live connection. That will give you the DAX query that was run to populate the visual.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

This is what I see when I export summarised data, I do not see the option "Excel with live connection"

Was this reply helpful? Yes No
lbendlin 8,551 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Interesting. Usually that setting is enabled by default. Are you on a Gov cloud? Or maybe your Power BI Tenant admin has modified that setting?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Not so sure, I am new to the Microsoft cloud suite

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

So is there any other way to automate it in power BI?

Was this reply helpful? Yes No
lbendlin 8,551 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

You can automate this but you don't need Power BI for it. You can run the same DAX queries from Power Automate or from other, more capable automation tools.

Was this reply helpful? Yes No