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!
Super UserHave you embedded your paginated report in a power bi report? If yes, then you would have created a hierarchical slicer in power bi report. You can bind the the parameters in your paginated report with their respective columns in power bi.
Checkout this video for more info.
https://www.youtube.com/watch?v=5Fcf8eXRq2E
Within your paginated report dataset query, you can use these parameter values to build the logic. From the example you shared, logic is to use sort of OR condition based on two parameter values.
Need a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
|
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.
- tharunkumarRTK
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!