Forum Discussion
Dave149
11 months agoFrequent Visitor
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...
- 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.
v-saisrao-msft
11 months agoCommunity Support
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.