We couldn't connect to the Analysis Services server. Make sure you've entered the connection string

[sykong]

I'm trying out Power BI Report Server and am getting this error message trying to run a report.

We couldn't connect to the Analysis Services server. Make sure you've entered the connection string correctly.

i'm not using SSAS so not sure why I'm getting this.  I saw a few threads on this already, but wasn't able to resolve with them. 

Also, the data sources tab is grayed out for me and have been unable to find a solution for why that is.  Hopefully someone here can help me out

Thanks!

[abbas-roshan]

"This apparently is a bug related to Power BI. The following page explains the solution."
https://medium.com/riccardo-perico/how-to-fix-couldnt-connect-to-analysis-service-in-power-bi-report...

[josef78]

Which version of PBIRS? It is issue on any report, or on live connected reports? When and where is this error message?

It looks as issues of some older release, or as misconfiguration PBIRS (wrong server name, or something like that)

[sykong]

Hi Josef78,  

I just installed it.  It's version 15.0.1114.33.  I'm on a 180 day free trial, if that makes a difference.  This occurs when attempting to run the report.  It will spin for a few seconds and then say "an unexpected error occurred".  Then I click on ErrorShowTechnicalDetails and then I get the couldn't connect to Analysis Services Server error .

This is a named instance (PBIRS).  This is because the server already has a regular instance of SSRS installed. Could that be an issue?

I only have the one report.  It uses Direct Connect going to an AWS Redshift instance.  I asked my developer to create a simple report just to see what happens.  I'll reply back when I find out.

Thanks!

[SaiTejaTalasila]

Hi @sykong ,

Are you able to run your reports on visual studio without any errors?.

Thanks,

Sai Teja 

[sykong]

Yes, reports ran just fine, so it looks like it's something with Redshift.  

[abbas-roshan]

https://medium.com/riccardo-perico/how-to-fix-couldnt-connect-to-analysis-service-in-power-bi-report...

[josef78]

Yes, also try create import mode report connected to AWS redshift, to narrow down where is problem ...