Error connecting to service using AdomdClient (.Net)

[teroman]

Hi,

I am trying to connect to the PowerBI service using the AdomdClient. I have installed the Sql2016 feature packs bits for SQL_AS_OLEDB and SQL_AS_ADOMD (Microsoft.AnalysisServices.AdomdClient.dll -> v13.0.0.0)

I can connect fine using COM/ODBO, but obviously using the .Net lib is far nicer. The connection string is out of the odc file I downloaded. I don't change the connection string between COM and .Net.

Hopefully the info below is sufficient, but if not please let me know!

Thanks

Colin

ConnStr:

Provider=MSOLAP.7;Integrated Security=ClaimsToken;Identity Provider=AAD;Data Source=https://analysis.windows.net/powerbi/api;Initial Catalog=sobe_wowvirtualserver-GUID;Location=https://wabi-north-europe-redirect.analysis.windows.net/xmla?vs=sobe_wowvirtualserver&db=GUID;MDX Compatibility= 1;MDX Missing Member Mode= Error;Safety Options= 2;Update Isolation Level= 2;User ID=my.account@work.com;Password=some_secret;

Message:

The value 'ClaimsToken' is not supported for the connection string property 'Integrated Security'.

Stack:

at Microsoft.AnalysisServices.AdomdClient.ConnectionInfo.CheckAndSetIntegratedSecurity(String key, String value)
at Microsoft.AnalysisServices.AdomdClient.ConnectionInfo.HandleKeyValueDuringConnectionStringParsing(String key, String value)
at Microsoft.AnalysisServices.AdomdClient.ConnectionInfo.ParseStringKeyValue(String stringToParse, KeyValueCallback keyValueHandler)
at Microsoft.AnalysisServices.AdomdClient.ConnectionInfo.SetConnectionString(String cs)
at Microsoft.AnalysisServices.AdomdClient.ConnectionInfo..ctor(String connectionString)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.set_ConnectionString(String value)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.set_ConnectionString(String value)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection..ctor(String connectionString)

ADOMD downloaded from http://download.microsoft.com/download/2/6/2/26225014-F04D-4D55-B341-20024494762D/ENU/X64/SQL_AS_ADO...

[tomtom]

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.

[teroman]

Didn't realise there was a Microsoft.PowerBI.AdomdClient.dll, thanks for that!

If anyone is looking for it, it's in the Power BI Desktop install folder, something like:

C:\Program Files\Microsoft Power BI Desktop\bin

[teroman]

Although I also get an exception saying "The remote name could not be resolved: 'analysis.windows.net'" so it's back to the COM world for me 😞

[pbidevusr]

Did anyone managed to figure this out? I am stuck at "The remote name could not be resolved: 'analysis.windows.net'" as well.