Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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
Solved! Go to 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 🙂
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 🙂
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
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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
39 | |
26 | |
21 | |
19 | |
10 |
User | Count |
---|---|
41 | |
36 | |
35 | |
20 | |
14 |