question

KamiFen-2811 avatar image
0 Votes"
KamiFen-2811 asked dgosbell answered

SSAS values not added up in Power BI

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LukasYu-msft avatar image
0 Votes"
LukasYu-msft answered LukasYu-msft edited

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

dgosbell avatar image
0 Votes"
dgosbell answered

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> )

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.