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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

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. It helps others in the community find answers faster—and keeps the community growing stronger!
You can also check out my YouTube channel for tutorials, tips, and real-world solutions in Power Query with the following link
https://youtube.com/@omidbi?si=96Bo-ZsSwOx0Z36h
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
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Top Solution Authors