Print dropdown list

[Anthony_BI]

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

[v-luwang-msft · Accepted solution]

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

[amitchandak]

@Anthony_BI , one way is power bi paginated report

https://docs.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-report-builder-power-b...

Export using python- not sure you can change filter -https://owlcation.com/stem/How-to-Export-Data-from-Power-BI

Power bi REST APIS.