Forum Discussion

Lora0121's avatar
Lora0121
Frequent Visitor
1 year ago

Error in Importing Excel File from SharePoint into Power BI

  Hello,   I am trying to import an Excel file from SharePoint into Power BI. I have an MS account with access to the file. However, when I try to use the SharePoint folder connect...
Need Help
collinq's avatar
collinq
Super User
1 year ago

HI Lora0121 ,

 

I am assuming that you do have the rights necessary to open the file?  And, I am assuming that the file is not password protected?  If so, then I am wondering about the way you are connecting to the file.  

 

You stated that this was an Excel file in SharePoint.  The way that I normally get an Excel file is to go to SharePoint, open the Excel file in the app (not just the browser).  Then, select Info and "copy path".

 

Then, in Power BI, use "web" connector and paste that URL (BUT, be sure to remove the ?web=1 from it though).

 

Let us know if that resolved the problem.