Power BI: We couldn’t connect to the Analysis Services server. Make sure you’ve entered the connection string correctly

In this article, I am going to solve the below issue:

We couldn’t run the report because we couldn’t connect to its data source. The report or data source might not be configured correctly.


Scenario

In Power BI Report Server, although I can browse the report properly in Power BI Desktop.

But when I tried to browse the newly published report from the Power BI Web Portal, I got the below error:

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

We couldn't run the report because we couldn't connect to its data source. The report or data source might not be configured correctly.

Environment:
  • Power BI desktop March 2018.
  • The SQL Server is the source of data
  • the connection is Direct Query, not Import Query.

Cause 

This issue usually occurs in case you are using “DirectQuery” to SQL Server database,
in this case, the data source is working properly in the Power BI desktop, but after publishing the report to Power BI Report Server, you got

“We couldn’t run the report because we couldn’t connect to its data source. The report or data source might not be configured correctly.”

In this case, you will need to provide again the login credential of the report data source from the Power BI Web Portal.


 

Solution

In the Power BI Report Server Web Portal, Make sure that
  • The user credential (Username & password) is provided correctly.
  • The assigned user in the data source has the sufficient permission to access the database.
Steps
  • Open Power BI Report Server Web Portal.

Power BI Report in Report Server Web Portal

  • Click on the report Eclipse ‘‘ > “Manage“.

Manage report in Power BI

  • From the right menu, select “Data sources“.
  • Provide the login data (Username, Password) again in a correct manner.
  • Click on Save.

Manage Data sources in Power BI Report Server

  • Browse the report that would be now working properly.

Display Power BI Report in Report Server


Applies To
  • Power BI.
  • Power BI Report Server.
See Also

Install and Configure Power BI Report Server

2 thoughts on “Power BI: We couldn’t connect to the Analysis Services server. Make sure you’ve entered the connection string correctly”

  1. Natisha Lapris

    Thanks for taking the time to discuss this, I feel strongly about it as well as love understanding more about this topic. Thanks alot…

  2. renato gamba australia

    I don’t think I’ve read something like this prior to. It is so nice to find an individual with some original ideas on this subject. I really appreciate an individual for starting up this way up. this internet site is something that is necessary on the web, anyone with a little originality.

Leave a Reply