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 ?
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 ?
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
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> )
4 people are following this question.
File for a cloned Vertipaq data object conflicts with a master data object file
dimension security on a combination of dimensions
integration services ne figure pas dans la liste des fonctionnalités partagées de sql server
Getting error message as "Unable to find any Microsoft OLE DB providers on the machine."
How to schedule SQL profiler to auto start/stop to capture SSAS synchronization?