Problems to connect an Excel file from Sharepoint to Power BI desktop

[Anonymous]

Hi, 

I'm really confused on the way to connect Excel file data from Sharepoint to PBI Desktop

I'm following the below video and of course I got blocked right away. 

https://www.youtube.com/watch?v=XuLnSYjmsJo

Here is what I try to achieve:

1. Connect My professional sharepoint to PBI Desktop

2. Find the excel file I am interested in and load the data/ import the data on PBI Desktop

3. Create a visualization

4. Get an update of the visualization every time the source file is updated. 

I'm using Power BI desktop for Report Server, with a professional account.

When I do: get datat > Sharepoint Online Folder > I enter the "home page" URL of my sharepoint > Transform data.

At this point I am in the Power Query Editor. In the column Folder Path I need to filter the list to get the folder path I am interested in: 

Text Filters > Contains > I enter the folder name I need to open to access the file I need to use. 

Here is the result: 

Did anyone have the same issue and was able to solve it? 

Or anyone has suggestions?

Thanks,

Melanie 

[Anonymous]

Hi  @Anonymous ,

This is the related document, you can view this content:

Re: SharePoint: Request failed: The remote server ... - Page 2 - Microsoft Power BI Community

SharePoint: Request failed: The remote server retu... - Microsoft Power BI Community

DataSource.Error: SharePoint: Request failed: The ... - Microsoft Power BI Community

Solved: DataSource.Error: SharePoint: Request failed - Microsoft Power BI Community

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[DataInsights]

@Anonymous,

Have you tried the Web connector? Use the full path of the Excel file through the end of the file name (delete characters after .xlsx).

[Anonymous]

Hi @DataInsights ,

Yeah, I tried with Web connector delete characters after .xlsx but I does not work either.