Forum Discussion

Kim_Maiden's avatar
Kim_Maiden
New Member
1 year ago
Solved

Paginated Report - Pulling Fields After Creation

Does anyone know how to add another field into a paginated report after it is created, and from same dataset as other fields already in the report? Like you forgot to pull something you needed.
Need Help
  • V-yubandi-msft's avatar
    V-yubandi-msft
    1 year ago

    Hi Kim_Maiden ,

    Thanks for the update. You seem to have added the column but are receiving blank values. This is probably because the field isn't being retrieved properly from the source.

     

    The following are a few things you should check.

    • Ensure the query included in your dataset actually contains the column which is missing. If you are using DAX or MDX then it might be necessary to alter the query, so the query is modified to include the new field.
    • Once you have added your column ensure it has been correctly mapped to the dataset field of Report Builder.
    • Try to refresh the dataset within Report Builder to ensure it's pulling the latest structure from its source.

    If your company is not using SQL, can you let us know what data source you're working with? This will allow us to be more specific.

     

    If my response solved your query, please mark it as the Accepted solution to help others find it easily!

    And if my answer was helpful, I'd really appreciate a 'Kudos'.

     

FarhanJeelani's avatar
FarhanJeelani
Super User
1 year ago

Hi Kim_Maiden ,

Yes! You can easily add a new field to your Paginated Report in Power BI without recreating the entire report. Here’s how:

Steps to Add a Field to an Existing Paginated Report

1.Open Your Report in Report Builder

  • Open Power BI Report Builder and load your existing RDL file.

2.Edit the Dataset

  • In the Report Data pane (left panel), find your dataset.
  • Right-click and select Dataset Properties.
  • Click Query Designer (if using a graphical query) or Edit as Text (for direct SQL queries).
  • Add the missing field and click OK.

3.Refresh the Dataset Fields

  • Right-click the dataset and select Refresh Fields.
  • The newly added field should now be visible in the dataset.

4. Add the New Field to the Report

  • Drag the new field from the dataset onto a table, matrix, or another report element.
  • Format as needed.

5.Preview and Save

  • Click Run to preview your report.
  • Save and deploy your updated Paginated Report to Power BI Service.

 

 

Please mark this as solution if it helps you . Appreciate Kudos.