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.
Hi
I have a SQL data source with 50M rows. I need to refresh my desktop monthly, but don't need all the data refreshed - just the new data added that month.
Is is possible to simply add the new data to the old data without doing the entire query again? It is massively time consuming.
Thanks
Hi @DataGuy2016,
In addition, here is a similar idea shared on Power BI Ideas. You can vote it up and add your comments there to improve Power BI and make this feature coming sooner.
Regards
Have a read of this blog. I think it's the best we can do on the current feature set.
While it will work ok, it will make your PBI Desktop model bigger than it needs to be
http://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/
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.
User | Count |
---|---|
111 | |
94 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |