topic Re: after jan PBIRS 2021 we get the "We couldn't connect to the Analysis Services server" error in Report Server

after jan PBIRS 2021 we get the "We couldn't connect to the Analysis Services server" error

Anonymous — Tue, 02 Mar 2021 15:09:28 GMT

HI!

After we upgraded our on premises powerBI server to the jan 2021 version, upgraded our PBIDesktopRS as well.

We have multiple PBIX files published to our on premises server all of them connected to our SQL server 2016 using DirectQuery mode.

After the upgrade, whenever we are executing any of them we get the following error.

"We couldn't connect to the Analysis Services server. Make sure you've entered the connection string correctly." on all our reports.

weird that on PowerBi Desktop RS they work, but when i publish them, we get that error on the server.

honestly im a newbie in this stuff and im trying to figure it out. Any help will be appreciated!

Re: after jan PBIRS 2021 we get the "We couldn't connect to the Analysis Services server" error

v-deddai1-msft — Thu, 04 Mar 2021 06:35:35 GMT

Hi Anonymous ,

Please firstly try to check the credential is provided correctly in report server and if the user have sufficient permission to access the database as the same as it is provided in power bi desktop for RS.

If all above are correct, please try to follow the steps below:

Copy the following libraries from the bin directory of PowerBI Desktop for RS into PowerBI Report Server's PowerBI directory

For Desktop for RS, copy the following files from C:\Program Files\Microsoft Power BI Desktop RS\bin (adjusting for your base installation directory)
1. Microsoft.AnalysisServices.AzureClient.dll
2. Microsoft.AnalysisServices.AzureClient.dll.manifest
3. msolap.dll
Copy the files to Power BI Report server C:\Program Files\Microsoft Power BI Report Server\PBIRS\PowerBI (adjusting for your base installation directory)

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

Re: after jan PBIRS 2021 we get the "We couldn't connect to the Analysis Services server" error

Anonymous — Fri, 05 Mar 2021 18:52:14 GMT

tried but with no avail... thanks for the workaround!

José

Re: after jan PBIRS 2021 we get the "We couldn't connect to the Analysis Services server" error

Anonymous — Fri, 05 Mar 2021 18:58:43 GMT

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

Re: after jan PBIRS 2021 we get the "We couldn't connect to the Analysis Services server" error

v-deddai1-msft — Mon, 08 Mar 2021 03:19:55 GMT

Hi Anonymous ,

It seems to be a credential error. Would you please check in the data source page if the credential have been set correctly and test connection for it:

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

Re: after jan PBIRS 2021 we get the "We couldn't connect to the Analysis Services server" error

Anonymous — Wed, 10 Mar 2021 06:22:47 GMT

把预览功能中的：使用增强的元数据格式存储数据集去掉

Re: after jan PBIRS 2021 we get the "We couldn't connect to the Analysis Services server" error

Anonymous — Wed, 10 Mar 2021 15:54:11 GMT

Put my credentials on it, it was with the user viewing the report, and it connected

but then when trying to run the report gave me this.

Re: after jan PBIRS 2021 we get the "We couldn't connect to the Analysis Services server" error

blynchdata — Wed, 10 Mar 2021 16:27:35 GMT

One thing that happens to me sometimes is I test my local Power BI RS report file pointing to a test server, but then I deploy the report to the production Report Server. The Report Server cannot access my test server data source, so I get the error you describe.

I go back into my local Power BI report file, point it to my production SSAS data source, then re-publish to the Report Server.

Could it be something like this?

Re: after jan PBIRS 2021 we get the "We couldn't connect to the Analysis Services server" error

Anonymous — Wed, 10 Mar 2021 17:16:39 GMT

actually i am pointing to the server it is going to reside finally. thats the weird thing! im not even using SSAS to this... im using a SQL server connectlion! whats what made me to ask for help here.

Thanks !

Re: after jan PBIRS 2021 we get the "We couldn't connect to the Analysis Services server" error

v-deddai1-msft — Thu, 11 Mar 2021 02:30:48 GMT

Hi Anonymous ,

It could be a kerberos error when you report server and sql server is not in the same sever. Please refer to the steps in https://docs.microsoft.com/en-us/power-bi/report-server/configure-kerberos-powerbi-reports

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

Re: after jan PBIRS 2021 we get the "We couldn't connect to the Analysis Services server" error

mojtabaparastar — Tue, 10 Sep 2024 18:07:49 GMT