cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
asas27
New Member

How to automatically prepare 1000 reports from Power BI with a template?

Hi Sir/Madam,

 

I got 5 tables loaded to Power bi.  For each table, the first column is the product name (XXX1....X1000).  I would like to pull all the relevant information from those 5 tables to generate 1000 individual reports for each product. 

 

For example, the template would be organized as below:

 

Summary of XXX1

 

Summary Table from Table 1 for XXX1

 

Bar Chart analyzed from Table 2 for XXX1

 

Summary Table from Table 3 for XXX1

 

Pie Chart analyzed from Table 4 for XXX1

 

Summary Table from Table 5 for XXX1

 

Would you mind to teach me how to prepare and generate all these reports automatically by Power BI?

 

Many thanks!

 

Best regards,

 

Catherine

1 REPLY 1
dedelman_clng
Super User II
Super User II

Hi @asas27 -

 

Do all 1000 reports need to be visible at the same time?  If not, sounds like what you're looking to do is have a slicer on "Product" that syncs across all 6 pages. Here's how to do that:

 

If you don't have just the list of products in a separate table in your data source, you can create it either in Power Query or in DAX.  The DAX method would be to create a new "dimension" table as the following:

 

Product = ALL(Table[ProductID])

 

This should give you a table called Product with 1000 rows and 1 column (Product Name).  Make a relationship between Product and each of the 5 data tables, linking Product Name each time.  This should create a 1-to-many (1 ---> *) between Product and each data table.

 

Build your report pages as normal.  Where you would use Product Name from the data table in the report, instead use Product Name from your new dimension table.

 

Once all of your pages are built, you want to create a slicer on the Product table (Product Name column).  Create this slicer on the first report page (suggest putting it in one of the corners, usually on the right), then copy and paste that slicer into each of the other report pages.  When you paste the slicer, Power BI will ask if you want to "sync" the slicers.  Choose "Yes" each time, and then when someone chooses a product on *any* page, the rest of the pages will be filtered to the same product as well.

 

Hope this helps

David




Proud to be a Super User!




Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors