Archive Data Set from Dashboard

[GTPowerBIUser]

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. 

[GTPowerBIUser]

wow, yes this is exactly what I needed

[GilbertQ · Accepted solution]

Hi @GTPowerBIUser 

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 Po...

[GTPowerBIUser]

@GilbertQ 

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.

[GilbertQ]

Hi @GTPowerBIUser 

When you say archive do you mean to get a copy of the data in Power BI?