topic Re: Paginated report problem in PBIRS in Report Server

Paginated report problem in PBIRS

Anonymous — Thu, 14 Nov 2019 09:00:12 GMT

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.

Re: Paginated report problem in PBIRS

RobThrive — Thu, 14 Nov 2019 11:51:29 GMT

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.

Re: Paginated report problem in PBIRS

Anonymous — Thu, 14 Nov 2019 12:00:20 GMT

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.

Re: Paginated report problem in PBIRS

RobThrive — Thu, 14 Nov 2019 14:40:51 GMT

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

Re: Paginated report problem in PBIRS

Anonymous — Thu, 14 Nov 2019 14:56:30 GMT

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.

Re: Paginated report problem in PBIRS

chrisklu — Fri, 18 Sep 2020 08:22:09 GMT

Hi!

Does anybody had fix this issue?

br, Chris

Re: Paginated report problem in PBIRS

chrisklu — Mon, 21 Sep 2020 08:19:52 GMT

Hi vdusan!

I have the same issue!

Have you found a solution for the issue?

br, Chris