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

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

KBO's avatar
KBO
Memorable Member
6 years ago

Hi Anonymous ,

try to rebuild your situation :).

This take a little time, may be in the meantime someone else find a soltuion. If not I'm still in ;).

 

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

     

    I just found this, please find attached screenshot, I always use Basic authentication for data source.

    Please suggest if I'm wrong here.

     

    Thanks,

    Bala

  • KBO's avatar
    KBO
    Memorable Member
    6 years ago
    Hi Bala, no you should use "using the following credentials" like I mentioned before in the post ;).

    Best,
    Kathrin