CommonDataService.Database is a function in the Power Query M language that connects to a Dataverse instance (Dynamics 365 and PowerApps). The function returns a connection to the specified instance for data access.
Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365
Syntax
CommonDataService.Database(
optional server as nullable text,
optional options as nullable record,
) as tableDescription
Connect to your Dataverse instance (Dynamics 365 and PowerApps).
Examples
An example that uses the CommonDataService.Database function is:
CommonDataService.Database(
"{crminstance}.crm.dynamics.com",
[ CreateNavigationProperties = false ]
)When you connect to Dataverse, there’s a way to make your queries run faster. You can do this by turning off something called “navigation properties” – these are columns that show relationships columns. To turn this off, just add “CreateNavigationProperties=false” when you’re setting up your Dataverse connection in the CommonDataService.Database function.
Think of it like choosing to load a lighter version of your data that skips the relationship information you might not need.
Related articles
Learn more about CommonDataService.Database in the following articles:
- Query Folding on Native Queries
This article delves into using Query Folding for Native Queries. It also provides a list of connectors that currently supports this. » Read more - Dataverse Connector
This article provides information on the Dataverse connector. » Read more
2023-2026 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy