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...
Forum Discussion
hey, this happend often around here, try setting the source to the root sharepoint instead of the specific site also you need to include the entire adrees: including the httpl:\\ from the begining. try those 2 part and let us know,
if this solved your question give some kudos and mark as solution for others to find.
I am having same issue regarding this. Does it have any solution?
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)
This fix worked for me. Thanks!
Hello, try to not use the button "Excel Workbook", use instead "Get Data-> Web" and put you path for the sharepoint file.
