Forum Discussion
Archive Data Set from Dashboard
What is the current preferred method to archive a data set? In reality I only need a very basic report from the dataset in a dashboard (that I own). I'm using Power BI Premium, and everyone in my...
Hi Anonymous
You are in luck, recently they have announced that you can now extract data via a query into a CSV file which you can then store in SharePoint. And as you said earlier using Power Automate
Here is the blog post: Unlocking new self-service BI scenarios with ExecuteQueries support in Power Automate | Microsoft Power BI Blog | Microsoft Power BI
Essentially the ask is that they want the exact power bi matrix visual dowloaded weekly into a csv for them to be able to reference as needed. If I can get the data extracted somehow automatically, then I can do the rest... Basically, the team doesn't want to have to download the data every week.