Forum Discussion

oroussel's avatar
oroussel
New Member
8 years ago
Solved

Why cant' I refresh my Power BI data from Excel when source is open?

Hello   When I refresh Power BI data from an Excel datasource, PBI refuses to do it if datasource is already open into Excel. This was the not the case fews month before.   I guess my issue is du...
Need Help
  • oroussel's avatar
    oroussel
    8 years ago

    Hi Pavlous

     

    Finally, I found the solution with your comment "In online excel it can cause issue, as it is still active anf everychange is overwriting it".

     

    My Excel datasource was located into a OneDrive directory. Now, I moved it to a standard directory (but not "Internet") and I can open simulteanoulsy Excel datasource and Power BI analysis > Save / upadte without any issue ! Perfect !!

     

    Thanks a lot for passing this "online" information !!

     

    Olivier

     

     

GAW's avatar
GAW
Frequent Visitor
8 years ago

I'm suprised it ever worked given to laod the data into PowerBI the app essentially has to open and lock the file and if the file is already open it can not lock so errors out.

 

I've given it a test my end and I get the same expected results as you so can confirm that's expected behaviour.

I can not see an instance where they will change it unless you connect to an o365 version that have collaborative working on - they may well have tweaked things for that instance but I havn't tested for that.