topic Re: Can I connect to Power BI data set using ADOMD.Net? in Developer

Can I connect to Power BI data set using ADOMD.Net?

volma — Wed, 20 Jul 2016 11:16:24 GMT

Hi!

I am using Microsoft.AnalysisServices.AdomdClient.dll, v13.0.0.0 to to access a Power BI data set from C# code. Have been experimenting with various connection strings but always get exceptions...

var connectionString = @"Provider=MSOLAP.7;Integrated Security=;Identity Provider=AAD;Data Source=https://analysis.windows.net/powerbi/api;Initial Catalog=XXXX-XXXX-GUID;Location=https://wabi-us-north-central-redirect.analysis.windows.net/xmla?vs=sobe_wowvirtualserver&db=XXX-XXX-GUID;MDX Compatibility= 1; MDX Missing Member Mode= Error; Safety Options= 2; Update Isolation Level= 2;User ID=my@workemail.com;Password=my_pswd;";
var conn = new AdomdConnection(connectionString);
conn.Open(); //throws here

The connection string above produces error "The connection either timed out or was lost."
This string is based on the .odc file that I downloaded from Power BI, and it works fine from Excel - data is loaded into pivot table, etc. (Excel uses COM driver I guess?)

If I set Integrated Security = SSPI or Basic, the client throws another error saying that neither of them can be used with HTTP.

What is missing in my code? I am looking for a working sample of a connection string for Power BI.

Thanks!

UPDATE: There is an inner exception for the connection string above: "The remote name could not be resolved: 'analysis.windows.net'" This url is what Power BI puts into odc file when I click on ANALYSE IN EXCEL. What url should I use to connect to data from .Net code?

Re: Can I connect to Power BI data set using ADOMD.Net?

Anonymous — Tue, 26 Jul 2016 16:35:02 GMT

Any update on this topic?

Re: Can I connect to Power BI data set using ADOMD.Net?

tomtom — Wed, 09 Nov 2016 13:27:31 GMT

The property Integrated Security=ClaimsToken has been working since version 13.0.1700.42 . The current version is available in Powerbi (Microsoft.PowerBI.AdomdClient.dll) and Excel2016 (Microsoft.Excel.AdomdClient.dll).

Unfortunately, I could not find out what is still wrong. For the data source https://analysis.windows.net/powerbi/api I get the error message that the host can not be solved and if I https://wabi-north-europe-redirect.analysis.windows.net/xmla I get the error message the authentication is not possible.

Re: Can I connect to Power BI data set using ADOMD.Net?

Anonymous — Sun, 28 Jul 2019 22:48:18 GMT

Any updates on this? I am trying to do the exact same thing with the same errors and exceptions.