Save data from a Flow - Source Control

[MortimerMcFly]

Hey @ All, 

I was just wondering if there is a way to save your data from a flow. I don't want to save the whole pbix file, but only the data that comes from the flow. 

Cheers!

[R1k91]

what do you need to do with the data "snapshot"?

if it's just a matter of backup you can backup power bi semantic models using the xmla endpoint. 

How to Backup and restore Power BI Premium semantic models - Power BI | Microsoft Learn

if you need to "attach" snapshot to current data you could use Dataflows Gen 2 to save the data into Lakehouse/Warehouse as files and then reaload them into your Power BI using Power Query.

[MortimerMcFly]

The goal is to have the historic data in form of a .csv or something because the data can change. 

Example: I reported value x in January but it can be different in may. In order to check what happened in the meantime I want to have the data from january saved somewhere. 

[R1k91 · Accepted solution]

do you need to export everything of just a subset of data (result of Table/Query)?

if everything needed:

• if you're in a fabric environment you could evaluate the native integration with onelake that automatically exports all the semantic model data to onelake in delta format during the semantic refresh. be aware it's in preview, requires fabric and has some limitations. Learn about Microsoft OneLake Delta table integration in Power BI and Microsoft Fabric - Power BI | ...

if subset of data:

•  you could run a DAX queries against your model and store the JSON outcome as you please Datasets - Execute Queries - REST API (Power BI Power BI REST APIs) | Microsoft Learn be aware it has some limitations.

• if you're in a Fabric ecosystem you could also levarage semantic link to run queries against your models and to store the result on the lakehouse as you please (csv or delta). Read data from semantic models and write data that semantic models can consume using python - Micro...