Analysis service connection don't show all data

Hi Raul ,

 

I don't have any experience with AS Cubes, but I do know that Power BI, by default, will only display rows in a visual where a measure resolves to a value, not NULL/BLANK.

 

For example, this table:

 

With this measure:

_thingyCount =
CALCULATE(
  DISTINCTCOUNT(table[ID]),
  table[thingy] = "A"
)

 

Will display this:

 

A few options:

1) You can right-click on a dimension that is in your visual from the Values list and check 'Show items with no data', to get something like this:

 

2) You can write your measure so that it resolves to zero if it would otherwise resolve to NULL/BLANK by just adding a '+ 0' at the end of it, to get something like this:

 

3) You can accept that PBI is only showing you relevant entries and communicate this to report users accordingly.

 

Pete

Hi Raul ,

 

What is the connection mode you are connecting to AS? If it is a live connection, try to use import mode to import data, then create the data model and check if the data is the same as the live connection.

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.