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
Matthias93
Helper III
Helper III

Connecting to excels on SharePoint

Hi,

 

I'm facing a strange issue in my dashboard. I'm getting data from multiple excels that are being stored on a SharePoint site. For some reason everytime I try to refresh I get the issue as you can see in the picture. The only way I have found to resolve this so far is to each time go to the query editor and reselect the excel and excel tab in the source and navigation step of the query. The path in the advanced editor is exactly the same before and after this operation. From a user perspective this really isn't a good thing. I just find the whole issue very strange. Has anybody encountered this before?

 

Kind regards,

Matt

 

Capture.PNG

1 ACCEPTED SOLUTION
hugoberry
Responsive Resident
Responsive Resident

I found that SharePoint webdav endpoint quite unreliable. I would recommend using the REST interface instead. Especially because you can access SharePoint lists directly from Get Data menu.

 

Your query might eventually look like this

=Excel.Workbook(Web.Contents("https://irm.be.deloite.com/Dahsboards excels/Retention.xlsx"),null,true)

View solution in original post

6 REPLIES 6
v-shex-msft
Community Support
Community Support

Hi @Matthias93

 

As hugoberry said, if you can please use sharepoint connector to connect the datasource. It may work through the issue.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Hi,

 

Is the only way to achieve this to create entirely new queries and relationships, or can I alter the existing query?

 

Thanks for your help.

 

Regards,

Matt

You can amend the query with replacing the data connection step with the example above. This should not require recreating the relationships.

Hey guys,

 

I slightly changed your path and it works perfectly. So far I get no errors when refreshing. Thanks a lot for helping me out.

 

Kind regards,

Matt

Anonymous
Not applicable

Hi @Matthias93, how did you originally connect to the SharePoint location? Did you use GetData > SharePoint option, or did you use the Web connection option?

hugoberry
Responsive Resident
Responsive Resident

I found that SharePoint webdav endpoint quite unreliable. I would recommend using the REST interface instead. Especially because you can access SharePoint lists directly from Get Data menu.

 

Your query might eventually look like this

=Excel.Workbook(Web.Contents("https://irm.be.deloite.com/Dahsboards excels/Retention.xlsx"),null,true)

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.