Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Solved! Go to Solution.
Hi There,
Currently You can not achieve this incremental loading of data in the PowerBI. Please see this ideas post and vote for it to get this feature in near future.
To achieve this functionality, you should create your model in SSAS Tabular and use PowerBI to connect to it.
Or
You create your model in PowerBI and load that in SSAS Tabular 2016.
For more information on incremental loading of data in SSAS Tabular, Visit this post.
Thanks & Regards,
Bhavesh
Hi There,
Currently You can not achieve this incremental loading of data in the PowerBI. Please see this ideas post and vote for it to get this feature in near future.
To achieve this functionality, you should create your model in SSAS Tabular and use PowerBI to connect to it.
Or
You create your model in PowerBI and load that in SSAS Tabular 2016.
For more information on incremental loading of data in SSAS Tabular, Visit this post.
Thanks & Regards,
Bhavesh
@robarivas if you right click the "..." on any data table in the tables view you get the menu shown below. I've been using "refresh data" to refresh a reasonably small table and it's dependencies (calc columns) when there are some huge tables that take hours to refresh and stress my 16gb ram computer to the max (100% cpu and 100% memory with nothing else running). I'll bet you can run this after you add a new table and need to load the data in the query. This may do what you're looking for. Tom
The best work around I can think of is to have a local copy of historical data and load the same using a separate query. For the newest data, run an R script with append=TRUE to achieve incremental load.
If the historical data is to be transformed, then first do all the transformation aqctivity in Power BI and then export the data to a csv using R Script to have a local copy of transformed and clean data.
Thanks to Imke Feldmann for this work around. However, I'm wondering on how to automate the date range for newest data based on the last date of historical data.
Would be great if someone can provide a soultion for the same. Meanwhile, we can vote here: Incremental Data Load