Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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

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: 

 

Melanie_S_1-1660666027891.png

 

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

Or anyone has suggestions?

 

Thanks,

Melanie 

 

3 REPLIES 3
v-yangliu-msft
Community Support
Community Support

DataInsights
Super User
Super User

@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).





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Anonymous
Not applicable

Hi @DataInsights ,

 

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

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.