Forum Discussion
Data is not showing up with values in Matrix Visual using SSAS Live Connection
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 |
4 Replies
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?
Thanks for your response. I am using Matrix visual for the report
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.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
