New Measure Error with SSAS Live connection

[PowerbiScp]

Hi all!

I connect with Power BI Desktop (latest version) to my SQL Server Analysis Service and i create a new Measure.

For example: NewMeasure = Sales[Value] / Sales[Quantity]. All works perfectly.

But when i try to use Sales[Value] or Sales[Quantity] in other visualization it returns me an error: "Unexpected exception" and also when i use this two Measures with Management Studio or Excel, it always gives me error "Unexpected exception".

Any ideas?

Thanks in advance for the replies and sorry for my bad english.

[Anonymous]

CU5 for SSAS fixed this issue for us

[Anonymous]

@PowerbiScp,

What version of your SQL Server Analysis Service(SSAS) and how do you create the two measures(Sales[Value] and Sales[Quantity]) in Analysis Service data model? Please make sure that you have installed the latest Service pack for your SSAS.


Regards,
Lydia Zhang

[PowerbiScp]

Hi Lydia,

the version of the Analysis SErver is 13.0.1601.5.

Te measures are simple SUM of a numeric column.

Regards

[Anonymous · Accepted solution]

@PowerbiScp,

Please install the latest Service pack and Cumulative Update for your SQL Server and then check if the issue still occurs.

Regards,

[PowerbiScp]

Thanks! We've solved the problem with the latest service pack installation!