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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s