This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreGet Fabric Certified for FREE during AI Skills Fest. This week only. Secure your voucher now.
I have built a page using drill through on a categaory.
Lets say I have n number of categories. when I click on 1 category and use drill through it gives me details of that category.
Need to create an export function which when clicked should download all the details of category page by page.
Dashboard layout
Home Page
Category drill through page
Export layout
Homepage
category 1 details
category 2 details
category 3 details
and so on.
Can somebody tell a solution or workaround.
Hello @Anonymous ,
check this out https://learn.microsoft.com/en-us/power-bi/collaborate-share/end-user-pdf?tabs=powerbi-service
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote For my Idea💡
Proud to be a Super User! | |
hi @Idrissshatila
the export should drill though on each category and generate the file.
Dashboard layout
Home Page
Category drill through page
Export layout
Homepage
category 1 details
category 2 details
category 3 details
and so on.
Hello @Anonymous ,
Power Bi Doesn't support to automatically drill through and export, you should do this manually or try to do it using Power automate.
https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-automate-power-bi-report-export
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote For my Idea💡
Proud to be a Super User! | |
Power Automate does allow drill through and export however only concern in my case is that I cant keep the track of no of categories and i need to print drill through report of all categories at once
Check out the May 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 23 | |
| 21 | |
| 21 | |
| 21 | |
| 16 |
| User | Count |
|---|---|
| 56 | |
| 55 | |
| 43 | |
| 26 | |
| 24 |