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!
Here's a tutorial on my preferred method to reference files from SharePoint - basically you put them in a shared team site, then swap out the path in the query from desktop to SharePoint. The tricky bit is getting the correct path for the file, since the normal "copy link" won't be the right one:
Hi christinepayton thank you for your response ---- it appears that the video you provided is set to private and inaccessible. Are you able to send a non-priviate link along? Thanks!
Whoops must have copied the wrong one 🙃 - try this? https://www.youtube.com/watch?v=LYu3wqb2Nx4
Also the error message you're getting makes me think you're selecting the incorrect authentication type when you enter credentials - make sure to select Microsoft account, not anonymous--
Hi Christine, thanks for the help on this! For the credentials, if I do have the Microsoft account selected what else should I try and checkout? Thanks!
