Creating tabs automatically

[Anonymous]

Hello,

I have quite tricky request from our client and I dont know how to solve it.

The client works with different retailers and these retailers can be active and inactive or buy/sell in any month.

Is there any way that Power BI can automatically create a tab if the retailer is active in the reporting month and provide details on visuals that I created in the general tab? 

PDF report should be provided at the end of the month. As of now, I am manually creating separate tabs for each exisitng retaler (could be more than 500 tabs) and filtering it by retailer code. Again, if next month the existing retailer closes and opens a new one, there will be new code and the existing tab just shows blank. 

Could you please help with any ideas? 

[v-jingzhang]

Hi @Anonymous 

If all tabs are the same except for the retailer data, I would suggest creating a single page and using slicers or filters to select retailer code and reporting month. It is not easy to manage more than 500 tabs in a report. And there is a limit when exporting reports from Power BI Service to PDF that reports with more than 50 report pages currently can't be exported. I am not sure if there is a page number limit if exporting from Power BI Desktop.

Best Regards,
Community Support Team _ Jing Zhang

[amitchandak]

@Anonymous , I doubt you can create a tab automatically

You can hide show based on need

https://www.fourmoo.com/2020/05/26/did-you-know-you-can-now-selectively-show-report-pages-for-specific-users-in-power-bi/

Log an idea for Tab- https://ideas.powerbi.com/ideas/

While you can schedule pdf fro power bi - https://powerbi.microsoft.com/en-us/blog/export-to-pdf-and-on-demand-e-mail-subscriptions-now-available/

You can R, Python on Power Automate to data export of PDF

https://sqlitybi.com/how-to-auto-schedule-data-export-from-power-with-pythn/

https://sqlitybi.com/how-to-auto-schedule-data-export-from-power-with-pythn/

https://www.thebiccountant.com/2015/12/28/how-to-export-data-from-power-bi-and-power-query/

https://owlcation.com/stem/How-to-Export-Data-from-Power-BI

[lbendlin]

If this is only for your internal use (to produce the PDF)  you can look into URL filters or bookmarks.

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters

That way you wouldn't need to create any additional tabs.

Automatic tab generation is not currently supported.