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 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 

    • KBO's avatar
      KBO
      Memorable Member
      6 years ago

      Hi Anonymous ,

      and the user you use is permitted to use the cube? You can successfully establish a connection but the user must be also allowed to use the data in the cube :). 

      Ahh...another point - the SQL Server is active (running)? I know stupid question but if the Server is inactive the report can't establish a connection and you can't see anything.

       

      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 ,

         

        Thanks for the feedback, I did cross-checked again and yes, user can access cube data also SQL server is running UP. Unfortunately still same error we are facing.

         

        Thanks,

        Bala