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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
aggisss
Frequent Visitor

Paginated reports - works only with access to the Workspace

I have 2 Power BI Reports with embedded Paginated Reports. Users used to have access to them through an App (without access directly to the workspace).

It worked until Christmas because I had users using both reports.

Now, users can navigate from a Power BI Report to an embedded Paginated Report only if they have access to the workspace (it can be a Viewer access). When accising the paginated report receiving following message:
"Sorry we couldnt find the report. It may have been deleted or you may not have access to view it".
After adding user as a viewer to Workspace it works.

5 REPLIES 5
vickyw
Helper I
Helper I

I am having exactly the same problem - my end user can only view the paginated report if they are added to the workspace as a 'Member'

The user definitely has
- a pro licence
- has been added to the app permissions
- app has granted access to the underlying data

From within the workspace, when I click the elipses, then manage permissions, I have added the user to the paginated report permissions, then repeated the same for the reports source dataset.

However, the user is still getting the following error:

Unable to render paginated report
There was an error communicating with Analysis Services. Please verify that the data source is available and your credentials are correct. No OLE DB Error Information found.
Timestamp: 2024-02-29T10:32:19.793Z
Root activity ID: 4ddf2682-db76-47e6-d786-d75f6d06b845
Session ID: 001e1640525e4c62ac6fa11b2faad239
Tenant ID: df0fc894-2330-4d89-8bde-dc1c1c6fc514
Cluster: https://wabi-north-europe-i-primary-redirect.analysis.windows.net/
Report ID: 91c75394-4863-4286-b966-255d02586417
Capacity ID: undefined
ReportViewerVersion: 2024.2.4.1338

Any help appreciated

PBI_Queryous
Advocate I
Advocate I

Turns you need to apply an additional layer of permissions on the paginated report artifact itself. You can still use Azure Security Groups. Having acces to the app is one thing, but then in the workspace, click on the paginated object elipses..anage permissiions and add your group/user there. Ive tried it. It definitely works.

GilbertQ
Super User
Super User

Hi @aggisss 

 

And you have double checked to make sure that they got access to the app?

 

Have you tried to remove them, update the app and add them back in again?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

aggisss
Frequent Visitor

Yes, They have permission to the dataset.

GilbertQ
Super User
Super User

Hi @aggisss 

 

Yeah that sounds like something has changed.

 

Do the users have read permissions to the underlying dataset from where the paginated report gets its data? That might also be something to look at.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.