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

[Gcanelaryenoso]

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

[v-saisrao-msft]

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.

[v-saisrao-msft]

Hi @Gcanelaryenoso,

Checking in to see if your issue has been resolved. let us know if you still need any assistance.

Thank you.

[v-saisrao-msft]

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]

Hi @Gcanelaryenoso,

Have you had a chance to review the solution shared by @Shahid12523?
Also, please check the following Microsoft documentation for your reference, which outlines the issue you’re experiencing:

Troubleshoot nested values returned as text - Power BI | Microsoft Learn

If the issue persists, feel free to reply here and we’ll be glad to help further.

Thank you.

[Shahid12523]

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.