Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Direct Query from SSAS cube Data Source on January-2020 Release of Report Server

Dear Team,   I'm using Direct Query from SSAS cube as data source into my RS Jan-2020 desktop and published into report server. I provided data source credentials under mange option in report serve...
Direct Query
Report Server
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hello KBO ,

     

    Thanks for support, I checked with Microsoft support team. 

    It's bug in Jan-2020 released version, for SAP BW and SAP HANA data source. They suggested work around in config files in report server and it's rectified now.

     

    Thanks.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hello Community/mgmeyer ,

 

Could you please assist me on below querry I'm facing.

 

Thanks,

Bala  

 

 

KBO's avatar
KBO
Memorable Member
6 years ago

Hi Anonymous ,

so let me recap your problem:

1) You use a SSAS (Cube) as Data Source (on premises I guess?)

2) You use a live connection to this Cube

3) You can't refresh or see anything in your report

 

Possible solutions:

Have you configured the SSAS? (https://subscription.packtpub.com/book/application_development/9781847197849/5/ch05lvl1sec06/configuring-sql-analysis-services-for-kerberos-authentication)

 

Other helful links for your case:

https://powerbi.microsoft.com/de-de/blog/how-authentication-with-analysis-services-live-connections-works/

https://antares.solutions/power-bi-report-server/

 

Best,

Kathrin

 

 

 

 

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hello Kathrin,

    Thanks for below comments, I have checked on SSAS configuration part for Kerberos authentication connection string is already updated accordingly. 

    I can view reports by using Import Query, also i can schedule refreshes in report server without any errors.
    But, if i use Direct Query we are facing issues as attached screenshot.
    Please help with work around for this issue.

    Thanks,
    Bala

    • KBO's avatar
      KBO
      Memorable Member
      6 years ago

      Hi Anonymous ,

      have you tried this:

      -> go to "Data Sources" of the report after you published it to server.And then manually enter the username and password?

       

      Best,

      Kathrin

       

       

       

       

      If this post has helped you, please give it a thumbs up!
      Did I answer your question? Mark my post as a solution!

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi KBO 

         

        Yes,  Data Source connection is successful but same issue in report.

         

        Thanks,

        Bala