You can't schedule refresh for this dataset because one or more sources currently don't support ref

[arvindyadav]

Hi Team.

When I publish my Power BI file which including multiple excel file looping through OneDrive in Power BI Service then I got a message like You can't schedule refresh for this dataset because one or more sources currently don't support refresh while Schedule refresh the dataset.

Please help me out.

Regards,

Arvind

[v-shex-msft]

HI @arvindyadav,

Did you use append or other functions which uses merge multiple files from onedrive?
If this is a case, current on premise gateway still not support merged/append files.

Regards,

Xiaoxin Sheng

[arvindyadav]

Hi @v-shex-msft,

I do not use merge/append query I just edited in advance editor for calling next excel files and it works in power bi desktop but when I publishing it into power bi service there is issue like I can't schedule refresh.

My advance editor changes are in bold letter:-

(i as number) as table =>

let

   Source = Excel.Workbook(Web.Contents("https://azureneebal-my.sharepoint.com/personal/powerbi_ms_neebal_com/Documents/Arvind/excel file name" & Number.ToText(i) & ".xlsx"), null, true),

   #"detailed_call_report_13-12-2017_Sheet" = Source{[Item="detailed_call_report_13-12-2017",Kind="Sheet"]}[Data],

   #"Promoted Headers" = Table.PromoteHeaders(#"detailed_call_report_13-12-2017_Sheet", [PromoteAllScalars=true]),

   #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"call_start_time", type datetimezone}, {"call_end_time", type datetimezone}, {"call_created_by_employee", type text}, {"call_time_in_secs", Int64.Type}, {"customer_id", Int64.Type}, {"customer_name", type text}})

in

   #"Changed Type"

[v-shex-msft]

Hi @arvindyadav,

I found you seems to use custom functions in query editor, right?
Current, query parameters and custom functions only works on power bi desktop.

Regards,

Xiaoxin Sheng

[arvindyadav]

Yes, That means if I made Change in advance editor then my schedule refresh not work?

[v-shex-msft · Accepted solution]

Hi @arvindyadav,

I just means custom functions and query parameter not support in power bi service. If your source table contains above features, you can't enable refresh features on power bi service

For normal functions(remove column, filter records, add custom column, unpivot columns...), they all works on power bi service.

Regards,

Xiaoxin Sheng