Forum Discussion
Scheduled Refresh not working - always another error message
When connecting to SharePoint online you can try and change the API version and see if that works?
Here are more details in the solved solution on how to solve it: https://community.powerbi.com/t5/Integrations-with-Files-and/Connecting-to-a-SharePoint-List-Office-365-error/m-p/8893/highlight/true#M1559
Hi Gilbert, thanks again.
I don't use a SharePoint-List as a Data Source. I go over "Excel.Workbook" and then over "Web.Contents" and there I don't have an API-Version.
Source = Excel.Workbook(Web.Contents("https://XYZ.sharepoint.com/sites/XYZTEa,/Shared%20Documents/XYZFolder/Core%20Data.xlsx"), null, true),
Calendar_Sheet = Source{[Item="Calendar",Kind="Sheet"]}[Data], #"Promoted Headers" = Table.PromoteHeaders(Calendar_Sheet, [PromoteAllScalars=true]), #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Date", type date}, {"Quarter", Int64.Type}, {"FinancialYear", type text}, {"Day", Int64.Type}, ...
I think that should work like this, no?
Thanks,
phil
Hi pnussbaumer
Yes that is how it should work.
Could I ask if you had to try and access the file directly would it work or not work?
Hello back,
I thought the same...
Yes, I have definitively access to it. I tried with many accounts; I even tried to give access to the files on SharePoint to the Account where I published the report from the Desktop.The weird thing is that under "Data source credential" is all "good" in the sense that there is no cross icon or so.
Any other idea? :-)
Thanks,
phil