Forum Discussion
Helper IIAppend new data into existing PBIX imported data
In your SQL Server database, do you have history data table and last month data table? If you donot like to append the new month database into history database and then refresh PBIX file, you could append it in your PBIX file. You need to modify you PBIX file, to add the latest sale sql database (with same schema & table), and then append it to history table.
For the details, please refer to the link below to see Combine Data section.
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-shape-and-combine-data/Regards,
Charlie Liao
Hi malikirfan28
I agree with v-caliao-msft, in that I would always still store all my data into the SQL Server database as the single source of truth.
It will then also make it easier to refresh and get the updated data.
There will be an upcoming option in the Power BI Premium license to do an incremental refresh which appears to be what you are after.
Microsoft Employee
In your SQL Server database, do you have history data table and last month data table? If you donot like to append the new month database into history database and then refresh PBIX file, you could append it in your PBIX file. You need to modify you PBIX file, to add the latest sale sql database (with same schema & table), and then append it to history table.
For the details, please refer to the link below to see Combine Data section.
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-shape-and-combine-data/
Regards,
Charlie Liao
Super UserHi malikirfan28
I agree with v-caliao-msft, in that I would always still store all my data into the SQL Server database as the single source of truth.
It will then also make it easier to refresh and get the updated data.
There will be an upcoming option in the Power BI Premium license to do an incremental refresh which appears to be what you are after.