Forum Discussion

JillHenninger's avatar
JillHenninger
Icon for Helper I rankHelper I
5 years ago

SharePoint Authentication Issues

Hi all I have a dataset that refreshes nightly and taps into 6 SharePoint based Excelf files and one OData (connected to a SharePoint list). Way more often than not, the dataset won't refresh due to...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

I am having same issue regarding this. Does it have any solution?

bwag2023's avatar
bwag2023
New Member
3 years ago

What finally worked for me was going to Transform Data, and changing the source of the query from:

= Excel.Workbook(File.Contents("\\sharepoint.com@SSL\DavWWWRoot\sitespath\excelfile.xlsx"), null, true)

to:

= Excel.Workbook(Web.Contents("https://sharepointsite.com/sitepath/filepath/excelfile.xlsx"), null, true)

 

 

  • BulldogTom's avatar
    BulldogTom
    New Member
    1 year ago

    This fix worked for me. Thanks!