Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I am creating Paginated Report based on PBI Dataset. I selected Dataset as Data Source, but while creating Dataset using Query Designer I get notification under "Measures" category: More Measures exist than can be shown.
And many measures needed for my report are not in my measure folder. How do I access full list of measures?
I tried adding them manually in querry Expression, but as soon as I add measures that don't show up in querry designer, I get this error:
Solved! Go to Solution.
You should be able to add your measures manually. That error most likely means you've made a syntax error in your query.
You should be able to add your measures manually. That error most likely means you've made a syntax error in your query.
I don't think it was syntax error, because I could not add even one column, and I copied syntax from existing columns. But I may have edited querry in the wrong form, as I'm not used to editing it manually.
The way I dealt with this issue was by creating new dataset in Power BI, based on data of existing Dataset. There I creaded new measure table with dublicates of all the measures needed for my Paginated report.
Then I used this dataset as source for my Paginated report.
This probably was not the best solution, but it was the fastest way I could deal with this.
@Raivo_S wrote:
I don't think it was syntax error, because I could not add even one column, and I copied syntax from existing columns.
If you were using the SummarizeColumns() function measures use a different syntax to columns so it is most likely your issue was related to a syntax error, but without seeing the text for your query it's impossible to know for sure.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
7 | |
4 | |
3 | |
2 | |
1 |
User | Count |
---|---|
7 | |
6 | |
6 | |
4 | |
3 |