locked
Problem with " RRS feed

  • Question

  • Hello. I'm using Power Query to extract data from my company database. We have measures called as following GRP E 20". When I tried to bring data from the source, I have  following exception:

    Expression.Error: La clave no coincidió con ninguna fila de la tabla.
    Detalles:
        Key=Record
        Table=Table

    It's because " in the name of the field.

    Power Query translate query on M as follows:

    = Cube.Transform(#"Elementos agregados1", {{Cube.AddMeasureColumn, "GRP E 20""", "[Measures].[GRP E 20""""]"}})

    It doesn't work and I don't kow how to do to fix that error.

    Thanks in advance!!

    Tuesday, March 8, 2016 4:53 PM

Answers

  • Ehren, this looks like the Anlaysis Services connector. It looks like maybe the UX is double escaping identifier for the measure.

    Igorin, can you try changing your query to:

    = Cube.Transform(#"Elementos agregados1", {{Cube.AddMeasureColumn, "GRP E 20""", "[Measures].[GRP E 20""]"}})

    Friday, March 11, 2016 8:04 PM

All replies

  • Hi there. What kind of cube are you accessing?

    Ehren

    Thursday, March 10, 2016 11:30 PM
  • Ehren, this looks like the Anlaysis Services connector. It looks like maybe the UX is double escaping identifier for the measure.

    Igorin, can you try changing your query to:

    = Cube.Transform(#"Elementos agregados1", {{Cube.AddMeasureColumn, "GRP E 20""", "[Measures].[GRP E 20""]"}})

    Friday, March 11, 2016 8:04 PM
  • Igorin, let us know if Tristan's suggestion fixes the issue for you.

    I've filed a bug for the double-escape issue.

    Ehren

    Monday, March 14, 2016 8:25 PM
  • It's works perfectly!!! thanks so much. Yes, it's an Analysis Services cube!!!!!

    thanks so much!!!!!

    Tuesday, March 15, 2016 8:46 AM
  • Yes, his suggestion has fixed the issue!!!!!!!!thanks

    Tuesday, March 15, 2016 8:47 AM