Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Paginated report problem in PBIRS

We have a PBIRS instance at our production environment, where the same user (with admin rights) uploaded both PBIX and SSRS paginated reports. Other users can access PBIX reports but paginated SSRS reports are not available. When those reports are clicked on they give us a login prompt but after a couple of tries at the prompt nothing comes up in the portal (blank page). It used to work and last week it stopped. We have test environment in different domain and it works withot error.

 

We've tried everything. When we use fiddler to trace it we get http 401 (unauthorized) error. We've created the report (rdl) which only display title without any database connection and we got the same error.

6 Replies

  • Is it asking you for login details for accessing the report, or is it asking you login details to the data source because they were not set in the RDL file before you uploaded it?

    If you have a custom data source (not shared) go to Manage --> Data source and ensure the correct user details are setup for accessing the data source.
    If you are using a shared data source, go ensure that is setup with the correct user details.

    If you are being prompted for user to login to access the actual report, check Manage --> security on the file.
    • Anonymous's avatar
      Anonymous
      Not applicable

      It is asking me for login details for accessing report.

       

      Security is OK, both custom data source and and shared data source are setup correctly. All reports work OK except paginated reports. 

       

       

      • RobThrive's avatar
        RobThrive
        Icon for Resolver I rankResolver I
        Have you checked the log file in the PowerBI RS install directory. I find it often has a lot more information available there.