Snapshot data from Power BI Report to Lakehouse

[zenisekd]

Hi, 

I am looking for the easiest way to snapshot calculated table results from Power BI report into a lakehouse. Year ago I have seen several videos on this topic, they used notebooks and dataflow I believe. Today I am having difficulties finding it. Could somebody advice? 

All I could find is this: https://www.linkedin.com/pulse/how-get-data-out-power-bi-microsoft-fabric-infuse-data-solutions-7cg8...

Thanks

David

[zenisekd · Accepted solution]

So the best solution I came up with was to use the Notebook, where I connected to a semantic model via semantic link. Did some dax evaluate in the notebook, in order to pull the data from the Power BI report, and stored the data in a lakehouse. Next I placed the notebook into a pipeline, where I did set scheduled activation. Finally, I used power flow to fine-tune the data. 

Some useful sources:
https://www.youtube.com/watch?v=zMiRGZsfQgs&t=2s&ab_channel=GuyinaCube
https://www.youtube.com/watch?v=x3eRU7NFdL0
https://medium.com/@sdaelemans/store-your-data-in-power-bi-to-onelake-with-semantic-link-in-microsof...
https://www.youtube.com/watch?v=bou77s-9b7c&t=264s

If anyone has something better please share 🙂

[Anonymous]

Microsoft Fabric: Write-back to OneLake - YouTube

[zenisekd]

Sorry, but this is not what I was looking for. Solution you posted requires Custom Power On visuals (a third party).

[Anonymous]

You are correct. I see some things about using Power Apps embedded but nothing about using dataflows

Using Power Apps in Power BI reports: Enabling writeback – Shabnam Watson's Blog

Shabnam did this presentation at Europe Fabric conference a couple of weeks ago

[zenisekd]

Well, the best I could find so far is using data pipeline (to orchestrate the start and destination) in combination with a notebook (to pull the data, perhaps via Semantic link).
https://learn.microsoft.com/en-us/fabric/data-science/semantic-link-power-bi?tabs=python
https://medium.com/@sdaelemans/store-your-data-in-power-bi-to-onelake-with-semantic-link-in-microsof...

https://www.youtube.com/watch?v=zMiRGZsfQgs&t=2s&ab_channel=GuyinaCube
https://www.youtube.com/watch?v=VAHOl9KqSsk&ab_channel=HoosierBI