Forum Discussion
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.
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'.
11 Replies
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.
https://learn.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-edit-service
Once you open the report in report builder, select the dataset, edit using Query Designer
Right click the datasets, to view the hidden datasets.
# # # #
This is old article but works the same way for editing datasets: https://www.mssqltips.com/tutorial/sql-server-reporting-services-ssrs-2017-data-sets/
When I do a new dataset, it deletes my current dataset and I lose all of my current work.
Hi Kim_Maiden ,
Thank you for reaching out to the Microsoft Fabric Community.
The solution provided by sevenhills & FarhanJeelani , is accurate and aligns with best practices. The official documentation shared also offers detailed insights. Please review it for a better understanding.Thank you for your valuable inputs sevenhills & FarhanJeelani .
Let us know if you need any further clarification. We’re ready to assist.Regards,
Yugandhar.
This did not work, but it may be that my company does not use Sql. I am not sure. I have tried to manually add the missing column into the code and it does come over into the builder but it gives an error when trying to run the report, like it is not actually connected to the source.
I did get it to let me add the column but it is not bringing back any data, just blank fields.
What is your source? what is your dataset contains SQL query, DAX, MDX, ... ?
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'.
Hi Kim_Maiden ,
We noticed we haven't received a response from you yet, so we wanted to follow up and ensure the solution we provided addressed your issue. If you require any further assistance or have additional questions, please let us know.
Your feedback is valuable to us, and we look forward to hearing from you soon.
Thank You.Hi Kim_Maiden ,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution we provided for your issue worked for you or let us know if you need any further assistance?
Your feedback is important to us, Looking forward to your response.
Thank You.
Hi Kim_Maiden ,
We are following up to see if the solution we provided resolved your issue. If you need further assistance or have any additional questions, please let us know. Your feedback is important to us, and we look forward to your response.
Thank You.
