Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
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 😞
Solved! Go to Solution.
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)
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
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
Proud to be a Super User!
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)
User | Count |
---|---|
89 | |
88 | |
84 | |
81 | |
49 |
User | Count |
---|---|
150 | |
142 | |
112 | |
73 | |
55 |