Forum Discussion
Data Load in Desktop
Hi Community,
I've around 15 millions of records in Sql Server table (Data Source) and I'm using Power BI Desktop to import data. I would like to import only new records. Instead of loading the refreshing the entire data everyday is there anything that i can load only current month data. I'm using Power BI Pro version.
Thanks,
Paruch
Hi Anonymous
There is something called incremental refresh which only updates changes or new data however this is only available to premium members. I would love this too.
The only way I have found around it is to have each week/month in a new table and then refresh only that table so it's much quicker. However, if you add a column you need to do it in all the table and not just one. It's very messy.
The only other way is to create a summary table first or cut out as much non-essential data while running the query editor.
I hope this helps, if it has please mark it as the solution :)
1 Reply
Hi Anonymous
There is something called incremental refresh which only updates changes or new data however this is only available to premium members. I would love this too.
The only way I have found around it is to have each week/month in a new table and then refresh only that table so it's much quicker. However, if you add a column you need to do it in all the table and not just one. It's very messy.
The only other way is to create a summary table first or cut out as much non-essential data while running the query editor.
I hope this helps, if it has please mark it as the solution :)