topic Re: Direct Query from SSAS cube Data Source on January-2020 Release of Report Server in Report Server

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

Anonymous — Sun, 12 Apr 2020 09:39:09 GMT

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

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

Anonymous — Mon, 13 Apr 2020 08:46:24 GMT

Hello Community/mgmeyer ,

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

Thanks,

Bala

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

KBO — Mon, 13 Apr 2020 08:56:02 GMT

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)

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

Anonymous — Mon, 13 Apr 2020 10:08:28 GMT

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

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

KBO — Mon, 13 Apr 2020 10:47:22 GMT

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!

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

Anonymous — Tue, 14 Apr 2020 03:16:44 GMT

Hi KBO

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

Thanks,

Bala

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

KBO — Tue, 14 Apr 2020 07:17:18 GMT

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!

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

Anonymous — Tue, 14 Apr 2020 08:07:22 GMT

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

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

KBO — Tue, 14 Apr 2020 08:13:23 GMT

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!

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

Anonymous — Tue, 14 Apr 2020 08:49:18 GMT

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

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

KBO — Tue, 14 Apr 2020 09:10:58 GMT

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

Best,
Kathrin

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

Anonymous — Fri, 24 Apr 2020 07:11:19 GMT

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.