Forum Discussion

teroman's avatar
teroman
Frequent Visitor
10 years ago

Error connecting to service using AdomdClient (.Net)

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....
Need Help
tomtom's avatar
tomtom
Regular Visitor
9 years ago

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's avatar
    teroman
    Frequent Visitor
    9 years ago

    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's avatar
      teroman
      Frequent Visitor
      9 years ago

      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's avatar
        pbidevusr
        Regular Visitor
        8 years ago

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