Forum Discussion

Dave149's avatar
Dave149
Frequent Visitor
11 months ago
Solved

Automatically extract data from report visual (live connection)

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 d...
Need Help
  • v-saisrao-msft's avatar
    v-saisrao-msft
    11 months ago

    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.

Dave149's avatar
Dave149
Frequent Visitor
11 months ago

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. 
v-saisrao-msft's avatar
v-saisrao-msft
Community Support
11 months ago

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.