Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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

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

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

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

    • Anonymous's avatar
      Anonymous
      Not applicable

      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's avatar
        Anonymous
        Not applicable

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