Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
vdusan
New Member

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 6
RobThrive
Resolver I
Resolver I

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.

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. 

 

 

Have you checked the log file in the PowerBI RS install directory. I find it often has a lot more information available there.

Hi, 

Yes I have. There is nothing in the log file, nothing in the events. It was working and than just stopped. Nothing was changed on the server and in our domain(update, security...)

 

In fiddler I can see http 401 for paginated reports for all other reports everything is ok. When I click on the report I get logon screen. When I enter my credentials 3 times I get blank page.

 

Very strange.

Hi vdusan!

 

I have the same issue!

 

Have you found a solution for the issue? 

 

br, Chris

Hi!

 

Does anybody had fix this issue?

 

br, Chris

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.