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 firm has a Power BI Pro license. I'm totally comfortable in Power Automate, so a solution using that tool is fine. My backend is Azure SQL Server. Technically I could just create a stored proc to move everything to a table, however I would need to re-create alot of measures/ calculations in the dashboard - so thats not my prefered method.
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
4 Replies
Hi Anonymous
When you say archive do you mean to get a copy of the data in 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.
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