Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Is there a work around for the Power BI Pro users to do incremental refresh of data?
Would there be M code or R scripting that would read existing tables and only append or update records, rather than reload the entire output?
We are moving to the CDS and using Power Query within the Dataflows and it does not provide further functionality to help this limitation.
Hi @steph_io
if you're using dataflows, you're in a good position: http://excel-inside.pro/blog/2019/03/01/incremental-refresh-for-pro-accounts-with-power-bi-service-d...
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
How do you connect the dataflow to an existing entity? When you use 'Get data' there is no source for the CDS like in the PowerBI desktop tool.
In a prior post I had asked a similar question on this subject. It seems the Dataflow always need to go back to the original source.
Is there a way to reference an existing entity from the dataflow?
thanks
Hi @steph_io
sorry, that was the wrong link. Just create the code in PBI Desktop and copy it to dataflows like described here: http://excel-inside.pro/blog/2019/03/21/classical-incremental-refresh-for-cloud-data-sources-in-powe...
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Hi
Thanks to ImkeF for providing such useful solutions.
Although it has some limitation, it may be helpful for many cases and provides many useful techniques.
Best Regards
Maggie
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.