Forum Discussion
We cannot convert the value \"[Function]\" to type Function
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.
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.