Help resolving Access Denied error when importing query built in exel, saved in sharepoint, into PowerBI?

Question

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 read this document (https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-import-excel-workbooks#are-there-any-limitations-to-importing-a-workbook) to help me with importing the query into Power BI. I know that I can use the file explorer to access OneDrive and import the book that way. My concern with this method though is if I were to get a new computer or leave the organization that the query would break since my OneDrive file path would no longer exist (or it would be altered) <--- Is this a legitimate concern or am I misunderstanding something here with using the file explorer to access SharePoint?

So I'm instead wanting to grab the URL for the query and paste that into the import action in Power BI and I'm receiving the error message above. From some google searching, it seems like this would be a possible method to help figure this out (https://learn.microsoft.com/en-us/sharepoint/manage-sites-in-new-admin-center).

However, I already have admin privileges and this should be able to work.

Can you help me troubleshoot this?!

Answer 1

Dear Victoria,

Good day!!

I understand you concern, you need help on importing query built in Excel into Power BI.

Considering that it is related to Power BI, you are more likely to get a good response to your question if you re-post to thePower BI Community forum, which is the dedicated channel handling this kind of issues.

This forum is geared more toward general question about Office and SharePoint.

Thanks for your understanding and cooperation! Hope you have a nice day!

Sincerely,

Tina | Microsoft Community Moderator