Forum Discussion

iamsordz's avatar
iamsordz
Frequent Visitor
5 years ago
Solved

Error connecting to Azure Analysis Services after PowerBI October 2020 upgrade

Hi    After upgrading the PowerBI report server from May 2020 to October 2020, connection to Azure Analysis Services is having error below: I am able to test successfully the connection in t...
PowerBI Report Server
  • gsprague's avatar
    gsprague
    5 years ago

    Hi iamsordz 

    Thank for your patience.  

     

    We have found a mitigation for some customers that are experiencing this issue in the October release. Let me know if the following works for you:

     

    Copy the following libraries from the bin directory of PowerBI Desktop for RS into PowerBI Report Server's PowerBI directory

    1. For Desktop for RS, copy the following files from C:\Program Files\Microsoft Power BI Desktop RS\bin (adjusting for your base installation directory)
      1. Microsoft.AnalysisServices.AzureClient.dll
      2. Microsoft.AnalysisServices.AzureClient.dll.manifest
      3. msolap.dll
    2. Copy the files to Power BI Report server C:\Program Files\Microsoft Power BI Report Server\PBIRS\PowerBI (adjusting for your base installation directory)

     

    Thanks,

    Gabe

  • iamsordz's avatar
    iamsordz
    5 years ago

    gsprague 

     

    Foudn a workaround and similar to your advice. Copied the same 3 files to the C:\Program Files\Microsoft Power BI Report Server\PBIRS\ASEngine

     

    Thanks.

iamsordz's avatar
iamsordz
Frequent Visitor
5 years ago

Thanks Anonymous for the reply.

 

I did install the latest PowerBI report server (2021/1/7) as shown in the screenshot below:

I tried the link you've provided, able to test connection successfully but still same issue when opening the report, see screenshots below. This report is OK prior the October 2020 upgrade.

 

 

 

Please note that the report data source is Azure Analysis Services tabular model.

 

Thanks and looking forward to your further advise.

 

Thanks.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi All

I have a similar issue using PowerBI Reports Server January 2020 connecting to Azure Analysis Services; after applying the above mentioned fix,workaround in our QA environment the reports work however when using the test connection in the data source configuration I get the following: 

Couldn't connect
The report server couldn't connect to the data source using the information you entered. Make sure you've entered the connection string and any credentials correctly.

Hide error details 
Unable to obtain authentication token using the credentials provided. If your Active Directory tenant administrator has configured Multi-Factor Authentication or if your account is a Microsoft Account, please remove the user name and password from the connection string, and then retry. You should then be prompted to enter your credentials.

I have confirmed that the account in question doesn't have MFA enabled and it only started throwing this error after applying the fix in this thread.

So before I take this to production I would just like some clarity or feedback from the community.

Power BI Reports server version -15.0.1102.777

Thanks