Append new data into existing PBIX imported data

[malikirfan28]

I need some expert guidance that how can I append new data into existing imported data of pbix file. I have created PBIX file after importing all sale history from SQL Database (4 tables) and it works perfect. 

Now every month, I recieve latest sale sql database (with same schema & table) which contain only last month data. Instead of appending this new month database into history database and then refresh PBIX file, is it possible to just append new database data into existing PBIX file?

Thank you in advance.

[v-caliao-msft · Accepted solution]

@malikirfan28,

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

[v-caliao-msft · Accepted solution]

@malikirfan28,

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

[GilbertQ · Accepted solution]

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.

https://powerbi.microsoft.com/en-us/power-bi-premium/