Forum Discussion
Scheduled Refresh not working - always another error message
Would it be possible to see the actual error message?
Are you running the latest version of Power BI desktop and the On-Premise data gateway?
Dear Gilbert,
thanks a lot for your feedback. Very appreciated.
Thats the whole message BUT the Table where it should happen is always another. So I got the same message with the Table "ABC", "XYZ", etc.
Last refresh failed: Fri Feb 15 2019 09:38:18 GMT+0100 (Central European Standard Time)
There was an error when processing the data in the dataset.Hide details
| Message: | The command has been canceled. Table: Finance: Revenue Targets. |
| Cluster URI: | WABI-NORTH-EUROPE-redirect.analysis.windows.net |
| Activity ID: | 3089d1fe-e9ae-4fe9-9327-79a2e60c9bab |
| Request ID: | ea610e85-e0ed-476d-8d1f-554bb9b822af |
| Time: | 2019-02-15 08:38:18Z |
I am running the latest PBI Desktop I think: 2.65.5313.841 32-bit (December 2018)
Oh, and very important: I don't use a gateway. The documents are all on SharePoint Online in a library. No on-premise.
Thank you,
philip
- HI there
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#M1559Hi 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?