Forum Discussion
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_DecklerCommunity Champion
I would submit this as a support issue. If you have a Pro account it is free. support.powerbi.com
- AnonymousNot 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
- AnonymousNot applicable
Hello nsrshkh, have you found a solution for that? I am also getting the same error.