cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
malikirfan28 Regular Visitor
Regular Visitor

Append new data into existing PBIX imported data

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.

2 ACCEPTED SOLUTIONS

Accepted Solutions
Moderator v-caliao-msft
Moderator

Re: Append new data into existing PBIX imported data

@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

Super User
Super User

Re: Append new data into existing PBIX imported data

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/


Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"
2 REPLIES 2
Moderator v-caliao-msft
Moderator

Re: Append new data into existing PBIX imported data

@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

Super User
Super User

Re: Append new data into existing PBIX imported data

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/


Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"