topic Re: All measures not showing up in Power BI Report Builder in Report Server

All measures not showing up in Power BI Report Builder

Raivo_S — Wed, 10 May 2023 04:59:01 GMT

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:

Re: All measures not showing up in Power BI Report Builder

d_gosbell — Wed, 10 May 2023 23:50:27 GMT

You should be able to add your measures manually. That error most likely means you've made a syntax error in your query.

Re: All measures not showing up in Power BI Report Builder

Raivo_S — Tue, 30 May 2023 07:35:50 GMT

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.

Re: All measures not showing up in Power BI Report Builder

d_gosbell — Tue, 30 May 2023 07:50:25 GMT

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.