Forum Discussion
Paginated Report - Pulling Fields After Creation
- 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'.
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.