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

     

     

oroussel's avatar
oroussel
New Member
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

 

 

MaryamBaghi1's avatar
MaryamBaghi1
Regular Visitor
2 years ago

Hi

What is standard directory ? 

please explain more🙏