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.

  • SDM_1997's avatar
    SDM_1997
    Helper II
    4 years ago

    Thank You very much for this.. 👍 😀
    Yeah, I just went to dataflow settings and changed the credentials..
    Strange when I was searching for this issue I could not find this forum post in the search. Only got 1 discussion with same issue but it was a different type of error 😅

  • 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

         

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    This was my issue. Once I clicked into the data source settings and cleared the permissions, I could go through the process again and it worked!