we cannot convert the value "[function]" to type function - Help

[Anonymous]

Hi All,

I am getting this message after scheduled refresh is failed we cannot convert the value "[function]" to type function.

I have combined multiple files from folder 2 times (Folder1 & Folder2) and merged both files.

As per suggestions I have turned off security (Fast Combine), however no result. 

Internal refresh is working, takes time due to number of files in folder

Online refresh whether it be "Refresh Now" or "Scheduled Refresh" gives above error.

I have checked and rechecked all the steps, got no luck in finding the challenge

Any help on this is appreciated. Thanks in advance.

Last refresh failed: Fri Mar 09 2018 18:16:10 GMT+0530 (India Standard Time)
Cannot connect to the mashup data source. See error details for more information.Hide details

Underlying error code:	-2147467259 Table: AR Data.
Underlying error message:	We cannot convert the value "[Function]" to type Function.
DM_ErrorDetailNameCode_UnderlyingHResult:	-2147467259
Microsoft.Data.Mashup.ValueError.Reason:	Expression.Error
Microsoft.Data.Mashup.ValueError.Value:	[Function]
Cluster URI:	WABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID:	0aeccabc-325d-4b86-8147-cbfc6c12ca58
Request ID:	64e69e2d-23f1-4749-96f2-74bddc08c710
Time:	2018-03-09 12:46:10Z

[Greg_Deckler]

I would submit this as a support issue. If you have a Pro account it is free. support.powerbi.com

[Anonymous]

Hi Smoupre,

Thanks for your reply

I have Power BI Pro account on my official id (I have registered with my personal id).

would you submit this issue to Power BI support.

Thanks

Nasir Shaikh

[Anonymous]

Hello @nsrshkh, have you found a solution for that? I am also getting the same error.