Forum Discussion
Power BI Report Builder_ Failed to preview report
I am trying to build a paginated report on Power Bi report builder. I have a valid stored procedure on my SqlServer DB. To keep the consistency of the design ( formatting, colors, text aligning) I created a copy of the existing report and deleted the dataset which was in it. And added my own dataset. Deleted the tablix column content from the existing report copy and filled the columns with my datasets columns.
But when I run the report, it shows:
" The hidden expression for the textbox 'Textbox11' has ascope parameter that is not valid for an aggregare function. The scope parameter must be set to a string constant that is equal to either the name of a containing group, the name of a containing data region, or the name of a dataset".
Did anybody come accross this issue in the past? How could you solve it?
2 Replies
R1k91Super User
have you already checked the "hidden" property for Textbox11?
maybe you left some dirty expression in it after removing the original dataset.
Hi, JulieKucher
As R1k91 said, maybe you can delete Textbox11 and try to create a new Textbox, see if this issue still exists.
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.
