March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi all,
We are building a Power BI dashboard which Connect Live to a SSAS data source. The issue we are facing now is with the Matrix visual. Whenever we trying to add a column (data type Text in SSAS) into the Values field, it only gives options of 'Count (Distinct)' and 'Count' as summarization type. However, the way we want the data to be displayed is text, so either 'First' or 'Last'. These options are actually exist in Power BI sourcing Database, so not sure if we can change something in the SSAS model to make it work.
The first screenshot is what it has in SSAS, and the second is what available in Database model.
Thanks in advance for ideas.
@yolanda_meng I have same issue with you. Don't summarize in matix only work when connecting to SQL Server datasource but not SSAS. Hope someone can help.
We have the same question. Anyone can help ?
Got same issue, any advice will be appreciated.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
123 | |
82 | |
69 | |
53 | |
44 |
User | Count |
---|---|
202 | |
106 | |
100 | |
64 | |
56 |