Scheduled Refresh not working

Question

Hi all,&nbsp;since days I try to figure out why my "Scheduled Refresh" is not working. The error message is always the same like "The command has been canceled. Table: Core: Currencies" - always another table, never the same.&nbsp;Facts:- I alwys get a file (Excel or CSV) from a SharePoint Online Library via "Web.Contents(...)".- In Power BI Desktop all is working fine.- Online (app.powerbi.com) I want to configure a scheduled refresh. So I did that AND edited the Credentials for every Data Source (what is always the same SP libaray and Credentials)&nbsp;That's it. And I always get these error messages and found nothing in a help or so,&nbsp;Thanks a lot for help!phil

gilbertq · Answer

Hi thereWould 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?

pnussbaumer · Answer

Dear Gilbert,&nbsp;thanks a lot for your feedback. Very appreciated.&nbsp;Thats the whole message BUT the Table where it should happen is always another. So I got the same message with the Table&nbsp; "ABC", "XYZ", etc.&nbsp;&nbsp;Last refresh failed: Fri Feb 15 2019 09:38:18 GMT+0100 (Central European Standard Time)&nbsp;There was an error when processing the data in the dataset.Hide detailsMessage:The command has been canceled. Table: Finance: Revenue Targets.Cluster URI:WABI-NORTH-EUROPE-redirect.analysis.windows.netActivity ID:3089d1fe-e9ae-4fe9-9327-79a2e60c9babRequest ID:ea610e85-e0ed-476d-8d1f-554bb9b822afTime:2019-02-15 08:38:18Z&nbsp;I am running the latest PBI Desktop I think:&nbsp;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.&nbsp;Thank you,philip

gilbertq · Answer

HI thereWhen 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

pnussbaumer · Answer

Hi Gilbert, thanks again.&nbsp;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.&nbsp;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}, ...&nbsp;I think that should work like this, no?&nbsp;Thanks,phil

gilbertq · Answer

Hi&nbsp;pnussbaumer&nbsp;
&nbsp;
Yes that is how it should work.
&nbsp;
Could I ask if you had to try and access the file directly would it work or not work?

Forum Discussion

Scheduled Refresh not working - always another error message

6 Replies

Related content

Schedule refresh

Schedule refresh

Refresh/ Scheduled Refresh sudddenly disabled

Scheduled Refresh Failure

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