connection error

[Anonymous]

Hi,

I need Help in this  error, how  I can fixed it

[v-yuta-msft]

@Anonymous ,

Does the connection work well on SSMS? Please check if analysis service is still running.

Community Support Team _ Jimmy Tao

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

[Anonymous]

@v-yuta-msft  thanks  for your  replay

I checked file  logo, the  error  message  in the  below :

A single value for column 'No' in table 'test' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.

[v-yuta-msft · Accepted solution]

@Anonymous ,

The error message mentions that the measure is not correct. You should add an aggregation function on column 'No' like SUM(), MAX() and others.

Community Support Team _ Jimmy Tao

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