Forum Discussion
Helper IIHierarchy slicer behavior on paginated report using parameter
In this case, I dont think you need to create a paginated report to export the data. You can use Executive dax query api. This will executive the dax query and and can extract the result.
https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/execute-queries-in-group
To make your user expereince better, you can use power atuomate flow and build the flow and embed this flow as a button in your power bi report. So that from your power bi report user will make the selections and clicks on the button and then he/she will receive the data as a data export.
https://www.youtube.com/watch?v=fbeMw9jtJB4
Need a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos.
Proud to be a Super User!
Helper IINo I dont embed the paginated report on power bi report, directly I try to export using rest api. However first of all I need to design the paginated report in reports builder with parameters. I can manage basic filter or range filter but problem with hierarchy filter.
Super UserIn this case, I dont think you need to create a paginated report to export the data. You can use Executive dax query api. This will executive the dax query and and can extract the result.
https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/execute-queries-in-group
To make your user expereince better, you can use power atuomate flow and build the flow and embed this flow as a button in your power bi report. So that from your power bi report user will make the selections and clicks on the button and then he/she will receive the data as a data export.
https://www.youtube.com/watch?v=fbeMw9jtJB4
Need a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
|