The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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"
Solved! Go to Solution.
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 @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?
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.
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.
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