How can I make Report Builder print the number of labels(pages)based on the value in the NumberPrint

[amal_01]

I am creating a Power BI Report Builder report. I have some product information including:

• Item

• Name

• Barcode

• NumberPrint (a column that indicates how many labels should be printed for each product)

For example:

• I have a product called Milk with NumberPrint = 3

• And Cheese with NumberPrint = 4

When I click the Print button, the report should print:

• Milk label 3 times

• Cheese label 4 times

How can I implement this in Power BI Report Builder?

[v-menakakota]

Hi  @amal_01  ,
Thanks for reaching out to the Microsoft fabric community forum. 
 

Could you let us know which type of data source you're using in Power BI Report Builder?

• Are you connecting to a Power BI Dataset (Semantic Model)?
• Or is your source SQL-based or another relational database?
  
  Regards,
  Community Support Team 

[amal_01]

Hi @v-menakakota 
 Power BI Dataset (Semantic Model)

[v-menakakota]

Hi @amal_01 ,
Thank you for the update.
Power BI Report Builder doesn't have a way to repeat rows based on a column like NumberPrint during runtime. So instead, you’ll need to prepare the data ahead of time in Power BI Desktop.

Add a custom column:

= List.Numbers(1, [NumberPrint])

Expand this new column this will repeat each product row based on the value in NumberPrint.

Load the data and publish your dataset to Power BI Service.

In Report builder connect to your published dataset.Use a List or Table control to create your label layout. Each repeated row will print as one label.

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

Best Regards, 
Community Support Team 

[amal_01]

Hi @v-menakakota 

Thanks. However, if I create this custom column, it will significantly increase the size of the dataset, which may cause refresh issues in the Power BI Service (such as timeout error messages).

[v-menakakota · Accepted solution]

Hi @amal_01 ,

In that case once try:

Apply a filter in Power BI Desktop before creating the List.Numbers column for example, filter by product name, category, or a specific date range. This way, only a smaller, relevant set of rows gets expanded, which helps keep the dataset size low and avoids timeout issues during refresh.

If I misunderstand your needs or you still have problems on it, please feel free to let us know.   

Best Regards, 
Community Support Team  

[v-menakakota]

Hi @amal_01 ,

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you

Thank you.

[v-menakakota]

Hi @amal_01 ,

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you

Thank you.

[v-menakakota]

Hi @amal_01 ,

I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.

Thank you.

[rohit1991]

Hi @amal_01 ,

Heres, how to Repeat Rows by NumberPrint in Power BI:

1. Load your product table into Power BI.

2. In Power Query (Transform Data), add a custom column:

   • Name: Repeat

   • Formula: = List.Numbers(1, [NumberPrint])

3. Click the expand button (arrows) next to the new Repeat column to expand it.
   This will duplicate each product row as many times as its NumberPrint value.

4. Remove the Repeat column if you don’t need it.

Now your data should have each product repeated as many times as needed. When you visualize or print labels, each product will appear the right number of times for label printing.

[anilelmastasi]

Hello @amal_01 ,

Is your source SQL Based?

[amal_01]

Hi @anilelmastasi 
Power BI Dataset (Semantic Model)