Forum Discussion
Print dropdown list
Hi everyone,
I have just created a report that I am happy with and now I would like to print it.
But my probleme is : I have a filter with a dropdown list (around 50 items) and I want to print 50 report with each item.
In fact, I can select the first item then print, do that with the second item etc...
But I need to do it every month and it is very tedious...
What is the best solution ?
I was thinkinf macros but if I am correct it is not available on power BI.
What about Python ?
Please can you help me
Hi Anthony_BI
You could try paginated reports . A major advantage of paginated reports is their ability to print all the data in a table, no matter how long. You can publish and share paginated reports in your My Workspace or in workspaces, as long as the workspace is in a Power BI Premium capacity. Power bi Pro license cannot use it currently.
More details you can see the below:
Tutorial: Create a paginated report and upload it to the Power BI service: https://docs.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-quickstart-aw
print data from power bi: https://community.powerbi.com/t5/Desktop/print-data-from-power-bi/m-p/1558722
Wish it is helpful for you!
Best Regard
Lucien Wang
2 Replies
- amitchandakSuper User
Anthony_BI , one way is power bi paginated report
Export using python- not sure you can change filter -https://owlcation.com/stem/How-to-Export-Data-from-Power-BI
Power bi REST APIS.
- v-luwang-msftCommunity Support
Hi Anthony_BI
You could try paginated reports . A major advantage of paginated reports is their ability to print all the data in a table, no matter how long. You can publish and share paginated reports in your My Workspace or in workspaces, as long as the workspace is in a Power BI Premium capacity. Power bi Pro license cannot use it currently.
More details you can see the below:
Tutorial: Create a paginated report and upload it to the Power BI service: https://docs.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-quickstart-aw
print data from power bi: https://community.powerbi.com/t5/Desktop/print-data-from-power-bi/m-p/1558722
Wish it is helpful for you!
Best Regard
Lucien Wang