The CData ADO.NET Provider for Microsoft Power BI XMLA implements the PowerBIXMLAProviderFactory class to enable you to write generic data access code to Microsoft Power BI XMLA through the ADO.NET base classes.

Creating Data Access Objects with PowerBIXMLAProviderFactory

The following sections show how to use the PowerBIXMLAProviderFactory class to create objects like PowerBIXMLAConnection, PowerBIXMLACommand, and PowerBIXMLADataAdapter in a generic way.

Register and Configure DbConnections

Register the provider to the configuration context and define the DbProviderFactory and DbConnection objects. See Creating DbConnections for a guide.

Querying Using DbCommands

Executing DbCommands describes how to use an existing DbProviderFactory and DbConnection object to execute queries to Microsoft Power BI XMLA.