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
jochenj
Advocate II
Advocate II

Paginated Reports with PBI Dataset - which permissions needed when publishing an App?

Szenario:

- I created with Report Builder a paginated Report, it has two datasources: AzureAS + PBI Dataset published in Workspace1

- I created a App1 in Workspace1 which includes the paginated Reports

 

Issue:

- Endusers, which are only granted permissions to the App are NOT able to open this report and get "connection to analysis services" not possbile!  --> When i remove the 2.Datasource (PBI Dataset) from the paginated report the reports start working wor endusers! So the issue is definitive related to missing enduser-permissions for the dataset inside the workspace

- If i set FULL/BUILD permissions for the user on the dataset this is NOT working

- If i share the paginated report (without app publishing) to the enduser this is also NOT working

- If i add the enduser as a member to the workspace the problem is SOLVED


Questions:

Which permissions needs to be set for endusers to be able to use the paginated report via app publishing and without the need to give the user workspace permissions?

 

Research:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-build-permissions --> This page highlights that the report builder author needs at leas BUILD permissions for the dataset. But no hint which permissions are needed for endusers consuming the paginated report 😞

 

 

 

1 ACCEPTED SOLUTION
jochenj
Advocate II
Advocate II

found the issue! 🙂

If the dataset has RLS defined you MUST add the enduser in pbi-service to a RLS role, otherwise you get not as expected an empty dataset result but instead this generic error "cannot connect". 

The enduser is good with "read" permissions on the dataset (no workspace permissions needed)

 

 

 

View solution in original post

4 REPLIES 4
Daviejoe
Memorable Member
Memorable Member

Hi @jochenj 

 

Great to hear you found a solution, I've had to learn and create a few Power BI Paginated Reports this year and I've learned a lot in terms of how to build them, parameters, visuals etc.

 

Good to meet another 'Paginator' for future reach outs!

 

David





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

Proud to be a Super User!




hi @Daviejoe , great, good to know that there are some more paginators  out there 😉  Also learned a lot in my recent activitites. I started long time ago with SQL SSRS2000 but found that there is still a bigger "update learning" needed for pbi paginated reports 😉

 

Currently i'm struggling with GLobals!RenderFormat variable (https://docs.microsoft.com/de-de/sql/reporting-services/report-design/built-in-collections-built-in-...)  That seems not to working in paginated reports 😞 used it a lot in SSRS times to control visible/hide of textboxes... when exporting to excel... but when using with paginated reports this is just without any effect.  Maybe you also did run in this issue already? is yes please pn

Hey @jochenj 

 

I'm not sure I fully understand the last issue, can you explain a bit more please?

 

David





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

Proud to be a Super User!




jochenj
Advocate II
Advocate II

found the issue! 🙂

If the dataset has RLS defined you MUST add the enduser in pbi-service to a RLS role, otherwise you get not as expected an empty dataset result but instead this generic error "cannot connect". 

The enduser is good with "read" permissions on the dataset (no workspace permissions needed)

 

 

 

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.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.