ADOMD.NET data provider connects to an analytics data source such as Power BI Premium, Power BI Desktop or SQL Server Analysis Services and provides a way to execute queries against that data source in a consistent manner that is independent of the data source and data source-specific functionality.
To add the extension for ADOMD.NET add a reference to the package `DubUrl.Adomd`.</a>
List of databases supported by ADOMD.NET data provider
| Database | Aliases | |||||
|---|---|---|---|---|---|---|
 |
asazure, asa | Microsoft.AnalysisServices.AdomdClient |  |
|||
 |
pbidesktop, pbix, powerbidesktop | Microsoft.AnalysisServices.AdomdClient | |
|||
 |
powerbi, pbi, pbiazure, pbipremium, powerbipremium | Microsoft.AnalysisServices.AdomdClient | |
|||
 |
ssasmultidim, ssasmdx | Microsoft.AnalysisServices.AdomdClient | |
|||
 |
ssastabular, ssasdax | Microsoft.AnalysisServices.AdomdClient | |
Example
Following example shows how to use DubUrl to connect to a Power BI Premium database.
Referencing the package of the ADOMD.NET data provider:
dotnet add package DubUrl.Adomd
Registering the factory of the ADOMD.NET data provider
DbProviderFactories.RegisterFactory("Microsoft.AnalysisServices.AdomdClient", DubUrl.Adomd.AdomdFactory.Instance);
Open a connection to the dataset of your tenant named dataset. Note that the scheme of the URL is set to pbiazure to specify that the database is a Power BI Premium (other options than pbipremium such as pbi or powerbipremium could have been used).
var conn = new ConnectionUrl("pbiazure://api.powerbi.com/v1.0/myorg/{dataset}").Open();
