topic Re: Data is not showing up with values in Matrix Visual using SSAS Live Connection in Report Server

Data is not showing up with values in Matrix Visual using SSAS Live Connection

Suresh4vkb — Wed, 13 Oct 2021 08:21:38 GMT

We have a requirement to show or hide the columns in Power BI Report, able to implement with matrix visual. But when we are using SSAS live Connection for Data,

Values are not showing the actual data (with First or Last options), it is showing with aggregated counts. When we use the same data with SSAS Import or SQL Data with Import, values are showing.

Below is the sample data

Username	Company	Country
SA11001	ABC	India
SA11002	ABC	India
SA11003	ABC	India
SA11004	XYZ	USA
SA11005	XYZ	USA
SA11006	XYZ	USA

Values are showing as count

Username	Count of Company	Count of Country
SA11001	1	1
SA11002	1	1
SA11003	1	1
SA11004	1	1
SA11005	1	1
SA11006	1	1

But we need to show data as below with SSAS Cube live connection. Please suggest how to resolve this issue

Username	First Company	First Country
SA11001	ABC	India
SA11002	ABC	India
SA11003	ABC	India
SA11004	XYZ	USA
SA11005	XYZ	USA
SA11006	XYZ	USA

Re: Data is not showing up with values in Matrix Visual using SSAS Live Connection

FarhanAhmed — Wed, 13 Oct 2021 11:30:10 GMT

it should not be happening if Company and Country are coming as Dimension Values. Are you using Table Visual or Matrix visual for your report?

Re: Data is not showing up with values in Matrix Visual using SSAS Live Connection

Anonymous — Fri, 15 Oct 2021 08:41:45 GMT

Suresh4vkb
Do you have the below option to choose? Change Count to First.

Or you can create 2 measures for each column, and use the measures instead of columns.

country measure=max([country])
company measure= max([company])

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

Re: Data is not showing up with values in Matrix Visual using SSAS Live Connection

Suresh4vkb — Wed, 20 Oct 2021 06:40:13 GMT

Thanks for your response. The first and last options are not displaying when we use data from SSAS Cube live connection mode. If we choose SQL/SQL import/SSAS Cube Import/Excel for data then the First and Last options are displayed. We are hoping it might be related to the data type issue

Re: Data is not showing up with values in Matrix Visual using SSAS Live Connection

Suresh4vkb — Wed, 20 Oct 2021 06:42:41 GMT

Thanks for your response. I am using Matrix visual for the report