SSAS values not added up in Power BI

KamiFen 121 Reputation points
2021-03-31T09:09:43.18+00:00

I just started to use Power BI, and connect to a tabular ssas database, I could load the values, but it seems I cannot have the total from them. Looks like power BI convert the column to text. How could I solve this ?

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,240 questions
0 comments No comments
{count} votes

Accepted answer
  1. Lukas Yu -MSFT 5,816 Reputation points
    2021-03-31T09:17:29.327+00:00

    Hi,

    Either from PowerBI side or from SSAS side, you could convert/set the data as value(number) format. You could find the data format property in you SSAS tabular project, change it into numbers(or just general), then build and deploy the project it should work out.
    Or in Power BI change the column format. See this : Power Bi not accepting values from SSAS columns

    Regards,
    Lukas

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Darren Gosbell 2,371 Reputation points
    2021-03-31T11:09:42.137+00:00

    When you are connected from Power BI in Live Connect mode to a model on SSAS Power BI cannot create implied measures like it would over an "internal" Power BI data set. All you need to do is to create an explicit measure in your tabular model which has an expression like SUM( <column name> )

    0 comments No comments