Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
i have a local excel file with power query (i am using the excel file for power BI)
all is working ok.
now i am trying to move this file to the share point and when i am changing the Data source in the power quary to the new location (using the same excel) i am getting the error message : The process cannot access the file.. it is being used by another process.. like a cannot working with power quary when the file is on Share point..
thank you
Solved! Go to Solution.
Open with excel and then used the link in the excel instead of URL. Please refer to:
Use OneDrive for Business links in Power BI Desktop - Power BI | Microsoft Docs
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
I got the same issue, I was using same folder for multiple query. I turned off parallel loading in power Bi options. It will load one table at once... and it works for me.
Open with excel and then used the link in the excel instead of URL. Please refer to:
Use OneDrive for Business links in Power BI Desktop - Power BI | Microsoft Docs
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
@oren , what method you have used to change the source.
Ceated a new correction using sharepoint. Open Power Query -> Right click on table -> Open advance editor -> Take the related code and replace it in advance editor of old table code
i change the address in the code and i got the same error
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |