cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Simon_Lou Frequent Visitor
Frequent Visitor

Understanding the interactions between Excel and Power BI

When importing data from Excel (and refreshing), would Power BI ever break an Excel file?  Can it be said that the Excel file is only being 'looked at' by Power BI and the Excel file will be unaffected?  Also, if a number of Power BI Desktop files are looking ar the same excel data source, will there be any performance issues?

 

Many thanks,

 

Simon_Lou

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Understanding the interactions between Excel and Power BI

My understanding is that Power BI simply reads the excel file.  There shouldn't be a risk of breaking those files.  Once it has opened the excel file, it will make a local cache of the information.  So there should be no performance hit, apart from the initial grabbing of the data, or whenever you need to grab the data updates.


   

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

Proud to be a Datanaut!


   


4 REPLIES 4
Super User
Super User

Re: Understanding the interactions between Excel and Power BI

My understanding is that Power BI simply reads the excel file.  There shouldn't be a risk of breaking those files.  Once it has opened the excel file, it will make a local cache of the information.  So there should be no performance hit, apart from the initial grabbing of the data, or whenever you need to grab the data updates.


   

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

Proud to be a Datanaut!


   


v-haibl-msft Super Contributor
Super Contributor

Re: Understanding the interactions between Excel and Power BI

@Simon_Lou

 

Based on my test, the Excel file still can be edited when importing or refreshing. So the Excel file should only being looked at.

 

Best Regards,

Herbert

Highlighted
Simon_Lou Frequent Visitor
Frequent Visitor

Re: Understanding the interactions between Excel and Power BI

@Ross73312 Thanks for clarifying this. Regarding the performance hit from the inital grabbing of the data and the refreshing. Is this performance hit only to Power BI and not the excel file?

Super User
Super User

Re: Understanding the interactions between Excel and Power BI

Yes that should be correct.


   

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

Proud to be a Datanaut!