Forum Discussion
Unable to render Paginated report
Thanks for the reply from lbendlin.
Hi Sham_24 ,
According to your description I have created data flow, datamart and paginated report, when granting the role of user workspace it is possible to render the paging report properly, here are my steps to do it:
1. Create a dataflow.
2. Create a datamart.
3. Create a paginated report:
4. Grant the user the viewer role.
5. Result:
Please make sure that your paginated report and datamart are both in the same workspace, and if not, give the user access to the other workspace as well. You can also try granting datamart permissions for the user.
Best Regards,
Zhu
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks Zhu for your response. I am using Direct Query connection in my Power BI Desktop report. I am using semantic model of that Power BI desktop report as data source for my Paginated report. I recreated the Power BI desktop report using import connection and then used that semantic model as data source for my paginated report. Now my user is able to render the paginated report. I still prefer direct query connects due to having large dataset. So I feel like the issue is Direct Query connection.