topic Re: Automatically extract data from report visual (live connection) in Developer

Automatically extract data from report visual (live connection)

Dave149 — Thu, 04 Sep 2025 08:50:16 GMT

Hallo,

How can I automatically extract the underlying data from Power BI report visuals that are based on live connections (e.g., to SSAS/AAS) and export it into CSV or Excel format for further downstream processing? What options or workarounds exist to achieve this?

Many thanks in advance!

Re: Automatically extract data from report visual (live connection)

Cookistador — Thu, 04 Sep 2025 09:06:00 GMT

The easiest way to achieve that would be to do it with Power Automate
Do you need to apply some slicer and then extract the data ? or it will be always the same visual just the date of refresh will change?

Re: Automatically extract data from report visual (live connection)

Dave149 — Thu, 04 Sep 2025 09:50:51 GMT

I tried using Power Automate with the action "Run a query against a dataset" and then provided it with the DAX query underlying the visual. However, that failed what I thought would be due to the live connection:

The dataset 'xyz' is a model hosted in Azure Analysis Services or SQL Server Analysis Services using On-Premise Gateway, which is not allowed.

Do you know any fix or other approach to it?

Slicers are not needed for now, just a refresh of the same visuals (so multiple ones) with the current data.

Re: Automatically extract data from report visual (live connection)

v-saisrao-msft — Fri, 05 Sep 2025 05:35:41 GMT

Hi @Dave149,

Thsnk you @Cookistador, for yyour insights.

For reports that use a live connection to SSAS, Power BI visuals do not support automatic export of underlying data. Instead, you can either query SSAS directly using tools like Excel, DAX Studio, or SSMS and export the results to CSV or Excel, or use Paginated Reports connected to the same model with subscriptions for scheduled CSV/Excel exports.

Thank you.

Re: Automatically extract data from report visual (live connection)

v-saisrao-msft — Mon, 08 Sep 2025 03:27:51 GMT

Hi @Dave149,

Have you had a chance to review the solution we shared earlier? If the issue persists, feel free to reply so we can help further.

Thank you.

Re: Automatically extract data from report visual (live connection)

v-saisrao-msft — Thu, 11 Sep 2025 09:35:08 GMT

Hi @Dave149,

Checking in to see if your issue has been resolved. let us know if you still need any assistance.

Thank you.

Re: Automatically extract data from report visual (live connection)

v-saisrao-msft — Mon, 15 Sep 2025 04:12:06 GMT

Hi @Dave149,

We haven’t heard back from you in a while regarding your issue. let us know if your issue has been resolved or if you still require support.

Thank you.