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.
Thanks Pavan! Does Dataverse.Database support Value.NativeQuery - PowerQuery M | Microsoft Learn?
I need to enabled query folding to support Incremental Refresh.
Hi Anonymous,
Thank you for reaching out in Microsoft Community Forum.
Yes, Dataverse.Database does support Value.NativeQuery, which enables query folding for optimized performance and supports Incremental Refresh
And please follow the below steps;
1. Use Query Diagnostics or right-click a step in Power Query to verify if folding occurs.
2. Make sure proper permissions for executing native queries and consider Dataverse API limitations.
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 Pavan,
I tried the following in the Power Query Advanced Editor:
let
Source = Dataverse.Database("<dataverse url>", [CreateNavigationProperties=false])
in
Source
and recieved the error message:
Expression.Error: The name 'Dataverse.Database' wasn't recognized. Make sure it's spelled correctly.Hi Anonymous,
Thank you for reaching out in Microsoft Community Forum.
Please follow below steps to resolve the error;
1.Check Dataverse Connector Availability and Make sure Dataverse appears in Power Query > Get Data and update Power BI if needed.
2.Enable Dataverse in Preview Features – Go to File > Options > Preview Features, enable Dataverse Connector, and restart Power BI.
3.Use the Power Platform > Dataverse UI to generate the correct M code and ensure proper environment access
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.