Forum Discussion
Help resolving Access Denied error when importing query built in exel, saved in sharepoint, into BI.
Hi Victoria-NHA
It seems that you are trying to use the following feature for an excel workbook stored in SharePoint.
In Power BI Desktop this feature launches the Windows File Explorer to find an Excel file. The problem is that the Windows File Explorer seems to only find files from the local drive/network folder/local OndDrive folder. When pasting the file URL in the File Name input box, I can reproduce the same error as the original post showed. I'm not sure if it can access a sharepoint folder through the File Explorer. I made many searches for this but found nothing helpful.
Since the action of this feature is a one-time event. Once created with these steps, the Power BI Desktop file has no dependence on the original Excel workbook. If your purpose is to store the Excel workbooks for further importing, you can store them in SharePoint. Next time when you want to import the queries, you just need to download the Excel file to the local drive and then import.
I hope this would be helpful.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
Loading Excel files into a workspace is generally frowned upon. Put the files on a (team) OneDrive and access them from there.
Can you elaborate on why it's frowned upon?
It's a bit of a black hole. You have to take Microsoft by their word that they will refresh the semantic model "within the hour" of changes in the file. You are also abusing the workspace as a data store. There are no guarantees whatsoever that this is a safe or reliable place to store data.