Getting Error while running the paginated report in report builder

[Pawan_123]

The 'Hidden' expression for the grouping 'DayOfMonth' refers to the field 'Date_Day_Of_Month'.  Report item expressions can only refer to fields within the current dataset scope or, if inside an aggregate, the specified dataset scope. Letters in the names of fields must use the correct case.

----------------------------

The definition of the report '' is invalid.

----------------------------

An error occurred during local report processing.

[Anonymous · Accepted solution]

Hi, @Pawan_123 

You need to make sure that the field name is spelled correctly and that the case exactly matches the name that appears in the dataset. Field names are case-sensitive. Also verify that the field 'Date_Day_Of_Month' is within the current dataset range. You can check the following link:

Troubleshoot paginated report execution issues - Power BI | Microsoft Learn

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.