Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

monaraya
Microsoft Employee
‎07-23-2020 12:44 AM

Unable to Open a Paginated Report in PBI Service

I recently came across an issue where few users in the organization were not able to open paginated reports in the PBI service.

Issue Description:

Specific users were not able to open the paginated report in PBI service which used to work fine in PBI Report Server.

Error Message:

Could not connect to the data source. There was an error communicating with Analysis Services. Please verify that the data source is available, and your credentials are correct. The connection either timed out or was lost.

S1.PNG

Typically, the members of the group were not able to view the report. By looking at this error, you might feel it’s an access or permission issue. But the actual issue turned out to be problem with the dataset connection.

Resolution:

  • In Report Builder, we refreshed the dataset connection by creating a new data source. This updated the connection string to the correct one.

S3.PNG

  • Post that, we refreshed the dataset connections for all existing RDL reports that have been built from that dataset.
  • Re-published the reports and it worked.

Author: Sumana Biswas

Reviewer: Mounika Narayana Reddy