topic Re: I am building a Matrix chart in Report Builder from PowerBI dataset but some data is missing in Report Server

I am building a Matrix chart in Report Builder from PowerBI dataset but some data is missing

Emelie20 — Sun, 06 Mar 2022 00:31:08 GMT

I am creating a Matrix chart in PowerBI Report builder using a PowerBI Dataset.

The original PowerBI Matrix is as shown below:

But the imgage I get in my Paginated report has blank values and no value under column "Site" as shown below:

I am wondering where the problem could be coming from.

When i use Query designer to execute the code, there are values under the "Site" Column.

Can anyone help me with a solution?

Thanks

lbendlin — Mon, 14 Feb 2022 00:59:12 GMT

Some of your hierarchy items are collapsed. Check your default settings for that visual.

v-henryk-mstf — Mon, 14 Feb 2022 06:24:17 GMT

You can refer to similar solutions to see if they help you.

If the problem is still not resolved, please point it out. Looking forward to your feedback.

Best Regards,
Henry

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