Forum Discussion

SDM_1997's avatar
SDM_1997
Helper II
4 years ago
Solved

Expression.Error: We cannot convert the value "[Function]" to type Function in Power Bi Dataflow

Hi All! So, I was trying to create dataflows by copying the same queries that are running in my Power Bi dataset. Now these queries run totally fine in the dataset. Using Power Bi Desktop for check...
Dataflow
Need Help
v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

Hi, SDM_1997 ;

The issue seems to be the privacy settings in Power BI Service.

Please try the suggestions mentioned in below link:

https://social.technet.microsoft.com/Forums/en-US/bee8a8e3-c8bd-48c6-a2c3-5d00bc5031b1/expressionerror-cannot-convert-the-value-quotfunctionquot-to-type-function?forum=powerquery

 

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

DCHAKRAV's avatar
DCHAKRAV
New Member
2 years ago

The provided lik says Page not found - what is the solution for this error?

  • SDM_1997's avatar
    SDM_1997
    Helper II
    2 years ago

    Hi DCHAKRAV 

    I do not remember it now exactly what was the solution..
    But you may try this once and check if ti solves the issue.

     

    Enable the combine data from multiple sources in the Privacy tab from the options settings in the DataFlow.

    After that just re-enter your credentials and it should work. 

    If there are still some issues then change the Privacy settings of all your data sources and make it the same like Organizational for all from the Manage Connections settings besides the Options settings. 

    • DCHAKRAV's avatar
      DCHAKRAV
      New Member
      2 years ago

      Thanks for the reply , it is working now . i changed privacy level in all data source . go to semantic model settings .  then data source credentials click on each data source and change setting to organizational

       

      • syed_s's avatar
        syed_s
        Helper I
        1 year ago

        I had the same issue yesterday. Your solution worked perfectly for my reprot. Thank you so much!

    • Luna2023's avatar
      Luna2023
      Frequent Visitor
      9 months ago

      Thanks a lot. My dataflow works after using the method you mentioned.