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

Updating Data in the power BI table

I am very new to power BI and have probably a very simple question to answer.

 

I have just finished my 6 hours of tutorial and it has showed me the power of BI which will be very useful for me and my company.

 

Currenlty I use a pivot table and manipulate it to give me the data I require.  Its not very 'sexey' and is just shown in a table with a small bar chart.  I would like to give much more visualisation and this will do the trick.

 

My first question is as follows.

 

Data is extracted from Microsoft Dynamics and the raw data is updated in a pivot table.  I am able to extract two years worth of data into a table and then import it into Power bi.  I would then like to add different tables and manipulate data.  I would also add a second table which contains my salesteams targets.

 

The raw pivot data is updated every day.  If I then import or update this from bi, will it not just overide all the additional columns I may have created?

 

Thanks

 

Nick

 

 

2 ACCEPTED SOLUTIONS
amitchandak
Super User IV
Super User IV

All calculations done on top of the data will work on the newly added data too.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

camargos88
Super User III
Super User III

Hi @nicksearle1966 ,

 

No, Power BI has a data model (like Excel), once you create you model only the data is refreshed. Like you said, you can have data from different sources (databases, flat files, excel, pdf, api...)

That's the amazing part of PBI, you work hard only once, after that it's just refresh.

 

Ricardo



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

Proud to be a Super User!



View solution in original post

6 REPLIES 6
Greg_Deckler
Super User IV
Super User IV

No, the data model remains, only the data is refreshed. It will replace all of the data every time though unless you use incremental refresh.

---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




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

Proud to be a Super User!




Hi Greg

 

If I have added columns to the original data , will it auto fill those columns aswell when I do an incremental refresh?

 

Thanks

camargos88
Super User III
Super User III

Hi @nicksearle1966 ,

 

No, Power BI has a data model (like Excel), once you create you model only the data is refreshed. Like you said, you can have data from different sources (databases, flat files, excel, pdf, api...)

That's the amazing part of PBI, you work hard only once, after that it's just refresh.

 

Ricardo



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

Proud to be a Super User!



View solution in original post

amitchandak
Super User IV
Super User IV

All calculations done on top of the data will work on the newly added data too.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Hi @amitchandak 

 

Thanks for the info.  I am sorry I didnt see you were first to reply

 

I had a supplementary question

 

If I have added columns to the original data , will it auto fill those columns aswell when I do an incremental refresh?

 

I will also certainly read your blogs.

 

Many Thanks

Hi @nicksearle1966 ,

 

As @amitchandak  said before,after the incremental refresh, the calculated column will also perform the calculation.

 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors