Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
Gcanelaryenoso
New Member

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:

Gcanelaryenoso_4-1756060755965.png

 

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.

 

Gcanelaryenoso_0-1756060317387.pngGcanelaryenoso_1-1756060513625.png

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

Gcanelaryenoso_2-1756060574519.png

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

Gcanelaryenoso_5-1756061044806.png

 

i will appreciate your help

 

thanks



3 REPLIES 3
v-saisrao-msft
Community Support
Community Support

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
Community Support
Community Support

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
Memorable Member
Memorable Member

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.

Shahed Shaikh

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Kudoed Authors