Forum Discussion

Gcanelaryenoso's avatar
Gcanelaryenoso
New Member
11 months ago
Solved

We cannot convert the value \"[Function]\" to type Function

Hi guys,

 

I hope your are doing well, i have a problema that ive been dealing with for some several days.

the error on the title is showing only on powerBi services but on powerBI desktop is working perfectly. 

 

this is the complete error:

 

the thing is that i am trying to conect to a folder in sharepoint and automaticly all excel files inside transform at the same time in power Query.

 

i have read the solution for this problem like:

-validate the  privacy settings in Power BI Service, i conected to organizational in powerBi service as in powerBI desketop.

 

i use the next option to conect to the sharepoint file:

These are the Power Query codes whose table the error refers to:

 

i will appreciate your help

 

thanks



Need Help

5 Replies

  • Shahid12523's avatar
    Shahid12523
    Community Champion
    11 months ago

    Why error happens:

    Power BI Service can’t resolve the Transform File function created by SharePoint Folder combine.

    Desktop works, but Service fails because of function + privacy/gateway mismatch.

    Fix:

    1.Make sure helper queries (Transform File, Sample File, etc.) are included in PBIX.

    2.In Service, configure SharePoint Folder (not SharePoint List) as data source.

    3.Set Authentication = OAuth2 and Privacy = Organizational (match Desktop).

    4.If still failing → edit M code to avoid [Function] and expand Excel directly with:

     

    Excel.Workbook([Content], null, true)


    instead of calling Transform File.

    Easiest first try: delete Service data source, republish PBIX, and reconfigure as SharePoint Folder with OAuth2 + Organizational privacy.

  • v-saisrao-msft's avatar
    v-saisrao-msft
    Community Support
    11 months ago

    Hi Gcanelaryenoso,

    Have you had a chance to review the solution we shared earlier? If the issue persists, feel free to reply so we can help further.

     

    Thank you.

  • v-saisrao-msft's avatar
    v-saisrao-msft
    Community Support
    11 months ago

    Hi Gcanelaryenoso,

    We haven’t heard back from you in a while regarding your issue. let us know if your issue has been resolved or if you still require support.

     

    Thank you.