Forum Discussion
Power Query Doesn't Recognize CommonDataService.Database
Hi Anonymous,
Thank you for reaching out in Microsoft Community Forum.
The Dataverse.Database function is supported in Power BI Desktop September 2024 or later. Make sure you are using the latest version, as older versions may not include this functionality.
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.
Hi Anonymous,
Thank you for reaching out in Microsoft Community Forum.
The error occurs because CommonDataService.Database is an outdated function name, and the correct function to use is Dataverse.Database. Microsoft rebranded Common Data Service (CDS) to Dataverse, and the function name changed accordingly.
Please follow below steps to solve this error;
1. Replace CommonDataService.Database with Dataverse.Database in your query.
Source = Dataverse.Database("<dataverse url>,5558", [CreateNavigationProperties=false])
2. Make sure you're using the latest version of Power Query and that your connector supports Dataverse.Database.
3. Enable the Dataverse Connector
In Power BI, go to File > Options and Settings > Options > Preview Features and check if Dataverse is enabled.
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.