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.
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.
- Click on the report Eclipse ‘…‘ > “Manage“.
- From the right menu, select “Data sources“.
- Provide the login data (Username, Password) again in a correct manner.
- Click on Save.
- Browse the report that would be now working properly.
Applies To
- Power BI.
- Power BI Report Server.
Thank you very much! I have exactly the same problem.
What I need is use SSO with Windows authentication as I read in the manual. I can use it with PowerBI Desktop but not on the web portal. Is there any way to use it instead of specify credentials with basic autentication?
Thanks for taking the time to discuss this, I feel strongly about it as well as love understanding more about this topic. Thanks alot…
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.