Forum Discussion

Victoria-NHA's avatar
Victoria-NHA
New Member
2 years ago
Solved

Help resolving Access Denied error when importing query built in exel, saved in sharepoint, into BI.

Hi everyone, I'm trying to import a query I built out in Excel into Power BI. I'm receiving the error message in the picture above and haven't been able to resolve why I'm getting the error.   I re...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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!

christinepayton's avatar
christinepayton
Most Valuable Professional
2 years ago

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-- 

blackanese27's avatar
blackanese27
Frequent Visitor
2 years ago

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! 

  • christinepayton's avatar
    christinepayton
    Most Valuable Professional
    2 years ago

    There's not a lot of info to go on about what you're currently doing - if it's working in Power Query in Excel, you should just be able to copy the advanced query text and paste it in a new blank query in Power BI and it should work. Make sure you're logged in with the same account. If you're doing the connect-locally-then-swap-paths technique from the video, just make sure you have the right link to the file. Presumably if you have permission enough to navigate to the place to copy the link, you should have enough permission to connect to it in Power BI. 🤨

     

    I'd take whatever URL you're using in the connection and paste it in a browser to make sure it's right/that you can access it, too--