Forum Discussion
Why cant' I refresh my Power BI data from Excel when source is open?
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
Hi oroussel,
If you are opening excel in desktop version and you are implementing the 'not opened' file inside PBI it shouldn't happen.
By the 'not opened' I mean the excel file which is created everytime you open excel before its closed again.
In online excel it can cause issue, as it is still active anf everychange is overwriting it.
If its the desktop option, make sure you have same version of excel file as the PowerBi is (x64 and x64) or Excel x86 and PBI x64 should work as well. But x64 excel and x86 PBI may cause the issue. It would also solve the backwards connection if you accidentally downloaded wrong version of PBI during updating it :)
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
Hi
What is standard directory ?
please explain more🙏
