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
Rachey
Regular Visitor

Connecting to Excel on SharePoint

Hi

 

What is the best way to connect to an Excel file on a SharePoint site?

 

I had originally connected using the standard Excel connector. This connected to the Excel file ok, but when the data changed in the Excel file refreshing in Power BI did nothing which makes me think this is not the best way to connect to SharePoint?

 

I tried SharePoint folder and SharePoint list and could not figure out how to make this work - I could only connect to the root URL and couldn't figure out how to get to my sub folder? Is there any documentation I can follow?

 

Thanks

Rach

2 ACCEPTED SOLUTIONS

@Rachey The trick is to just get the right URL path, its worth the effort. Here is a blog tutorial -> https://powerbi.tips/2016/09/loading-excel-files-from-sharepoint/


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

Hi @Rachey,

 

It seems that you have problems with connecting excel on Share Point.

 

Have you solved your problem?

 

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

 

If you still need help, you could have a reference of this similar thread.

 

In addition, you could have a look at the blog below about the ways to conncet excel filed in SharePoint.

 

https://social.technet.microsoft.com/wiki/contents/articles/40040.power-bi-two-way-to-get-data-from-...

 

If your excel is online, you don't need to configure the on-premise Gateway, if your excel is local file, you need to configure the on-premise Gateway.

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4

@Rachey The trick is to just get the right URL path, its worth the effort. Here is a blog tutorial -> https://powerbi.tips/2016/09/loading-excel-files-from-sharepoint/


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

Thanks @Seth_C_Bauer. This helped me find the correct root 🙂

 

Unfortunately I'm still having problems, but I'm not sure if this is a Power BI issue or a SharePoint issue. When I load the data into the query editor it doesn't show all the folders, and weirdly the latest date modified is July 2016. Is there a capacity limit to the number of folders that it can locate?

 

I'm going to have to continue with the Excel connector till I can resolve this SharePoint issue. Just for clarity, I'd like to understand:

* Is the SharePoint folder connector considered better practice? And does this mean I won't need to create an enterprise gateway to refresh dashboards in Power BI online?

* If I use the Excel connector to the SharePoint folder will I need the enterprise gateway?

 

Thank you. Very much appreciate the help.

Rach

Hi @Rachey,

 

It seems that you have problems with connecting excel on Share Point.

 

Have you solved your problem?

 

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

 

If you still need help, you could have a reference of this similar thread.

 

In addition, you could have a look at the blog below about the ways to conncet excel filed in SharePoint.

 

https://social.technet.microsoft.com/wiki/contents/articles/40040.power-bi-two-way-to-get-data-from-...

 

If your excel is online, you don't need to configure the on-premise Gateway, if your excel is local file, you need to configure the on-premise Gateway.

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@Rachey I don't recall the details off the top of my head, but I believe there are authentication issues with having the Excel file in the cloud and not being able to connect via Oauth2.... I forget at the moment. I do recall having to flip a solution to use the SharePoint folder instead. It sounds like you have a path, but not the right level. There are no restrictions on what it should see as you describe.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

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.