Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
93 | |
87 | |
80 | |
69 | |
68 |
User | Count |
---|---|
226 | |
129 | |
119 | |
83 | |
77 |