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

[Anonymous]

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 server, Test connection is successfull. while accessing application below is the error facing. Request you to kindly help on this ASAP.

I used same data soucre with same credentials using Import Query, it works for as expected and able to schedule refreshes also. Only problem is by using Direct Query.

Version Using: Report Server - Jan 2020

                        Desktop - Microsoft Power BI Desktop (Optimized for Power BI Report Server - January 2020)

Thanks,

Bala

[Anonymous]

Hello Community/@mgmeyer ,

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

Thanks,

Bala  

[KBO]

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]

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]

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]

Hi @KBO 

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

Thanks,

Bala 

[KBO]

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]

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]

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]

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]

Hi Bala, no you should use "using the following credentials" like I mentioned before in the post ;).

Best,
Kathrin

[Anonymous · Accepted solution]

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.