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
