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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Mixednuts
Helper III
Helper III

Sharepoint.Contents() documentation error?

The documentation for the Sharepoint.Content() function in Power Query refers to an optional parameter "Implementation"

SharePoint.Contents - PowerQuery M | Microsoft Learn

I am currently using the January 2025 version of the desktop and I get this error when I try to reference "Implementation"

Mixednuts_0-1739264951641.png

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @Mixednuts,

Thank you for reaching out in Microsoft Community Forum.

Thank you @Omid_Motamedise ,  @Akash_Varuna  for the helpful responses.

The official Power Query Blog on Microsoft Tech Community shares updates, new features, and changes to Power Query regularly. It's a great resource for staying informed about new developments and function updates.
https://learn.microsoft.com/en-us/power-query/

Please continue using Microsoft community forum.

If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.

Regards,
Pavan.

View solution in original post

5 REPLIES 5
Mixednuts
Helper III
Helper III

Thank you @Omid_Motamedise and @Akash_Varuna 

I will treat it as a documentation issue and have reported it as feedback on the document. 

Is there a means by which we can monitor changes to Power Query functions? eg a blog?

Anonymous
Not applicable

Hi @Mixednuts,

Thank you for reaching out in Microsoft Community Forum.

Thank you @Omid_Motamedise ,  @Akash_Varuna  for the helpful responses.

The official Power Query Blog on Microsoft Tech Community shares updates, new features, and changes to Power Query regularly. It's a great resource for staying informed about new developments and function updates.
https://learn.microsoft.com/en-us/power-query/

Please continue using Microsoft community forum.

If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.

Regards,
Pavan.

Thank you @Anonymous I explored the link you sent at length but could not find anything that specifically referred to "What's New" in the M language.

I have found several random third party references to changes in the language, particularly the function definitions (new, modified, depricated), the most recent from Chris Webb (Reading Delta metadata in Power Query)

Do I assume an official source does not exist?

Thanks for your feedback.

Omid_Motamedise
Super User
Super User

The SharePoint.Contents() function in Power Query is designed to retrieve a table containing a row for each folder and document found at a specified SharePoint site URL. The optional options parameter allows you to control certain aspects of the function's behavior.
In your case, you're encountering an error when attempting to use the Implementation option with SharePoint.Contents(). This issue may be due to the specific version of Power BI Desktop you're using (January 2025). It's possible that this version does not support the Implementation option for the SharePoint.Contents() function, or there might be a syntax issue in how the parameter is being applied.


If my answer helped solve your issue, please consider marking it as the accepted solution.
Akash_Varuna
Super User
Super User

Hi @Mixednuts , I think it might be because of parameter is no longer valid in the latest Power Query versions

Try these please 
Use only the ApiVersion parameter
SharePoint.Contents(SharepointSource, [ApiVersion = 15])

The parameters update frequently so that might be causing this
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors