Forum Discussion

PowerbiScp's avatar
PowerbiScp
Frequent Visitor
9 years ago
Solved

New Measure Error with SSAS Live connection

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.

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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's avatar
      PowerbiScp
      Frequent Visitor
      9 years ago

      Hi Lydia,

      the version of the Analysis SErver is 13.0.1601.5.

      Te measures are simple SUM of a numeric column.

      Regards

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    CU5 for SSAS fixed this issue for us