Error: Something wrong with KPI since yesterday

[AlessandroGAVB]

Yersteday we started to have an issue where we can't connect or update the model anymore.
We solved when we removed a KPI that works before. Until 2012-12-15 03:00 am (GMT-3:00) it works fine.

We get the following error on report attached to dataset:

Underlying Error: Exception while parsing CSDL to create Conceptual Schema. Model ID=1725844
Activity ID: 120b228d-c4ca-4444-9c50-152ee2c9e708
Correlation ID: ee9b396a-ab91-6008-004c-6f1a7ab596e7
Request ID: e705d683-15ee-944d-ddf0-d62ce8548ea4
Time: Fri Dec 16 2022 08:36:29 GMT-0300 (Brasilia Standard Time)
Service version: 13.0.19635.59
Client version: 2212.1.11454-train
Cluster URI: https://wabi-brazil-south-b-primary-redirect.analysis.windows.net/

And this when we tried to connect to dataset from Power BI Desktop:

The '' string cannot be converted to the unsignedInt type

This is the script to create the KPI:

{
  "create": {
    "parentObject": {
      "database": "dc5f3ef8-ffd1-4466-a493-f403e837cd89"
    },
    "table": {
      "name": "KPIs",
      "lineageTag": "adfa28ed-4ba7-43ba-91c2-ece004566ef1",
      "partitions": [
        {
          "name": "KPIs-2e7578b1-4d92-46ae-87f0-d1860017cee5",
          "mode": "import",
          "source": {
            "type": "m",
            "expression": [
              "let",
              "    Fonte = Table.FromList({\"\"}),",
              "    #\"Removed Columns\" = Table.RemoveColumns(Fonte,{\"Column1\"})",
              "in",
              "    #\"Removed Columns\""
            ]
          }
        }
      ],
      "measures": [
        {
          "name": "Sellout.",
          "expression": "[Sellout]",
          "formatString": "#,0.00",
          "displayFolder": "Sellout",
          "lineageTag": "2dee783e-ac1c-4ffa-a901-5eea38f64c3d",
          "kpi": {
            "targetExpression": "[Meta Geral]",
            "targetFormatString": "#,##0.00",
            "statusGraphic": "Three Circles Colored",
            "statusDescription": "Comparação do período sobre a meta. Faixas: < meta, neutro, >= meta.",
            "statusExpression": [
              "VAR _value = [Sellout]",
              "VAR _target = [Meta Geral]",
              "RETURN",
              "    IF (",
              "        NOT ISBLANK ( _value ) && NOT ISBLANK ( _target ),",
              "        SWITCH (",
              "            TRUE,",
              "            //_value > _target, 1,",
              "            _value < _target, -1,",
              "            1",
              "        )",
              "    )"
            ],
            "trendGraphic": "Status Arrow - Ascending",
            "trendDescription": "Comparação do período sobre o anterior. Faixas: < 25%, < 5%, neutro, > 5%, >25%.",
            "trendExpression": [
              "VAR _curr = [Sellout]",
              "VAR _prev =",
              "    SWITCH (",
              "        TRUE,",
              "        ISINSCOPE ( 'dim_tempo'[DescricaoMesAno] ) || ISINSCOPE ( 'dim_tempo'[DescricaoMes] ) || ISINSCOPE ( 'dim_tempo'[DescricaoMesABR] ) || ISINSCOPE ( 'dim_tempo'[IdAnoMes] ) || ISINSCOPE ( 'dim_tempo'[IdMes] ),",
              "            CALCULATE (",
              "                [Sellout],",
              "                DATEADD ( 'dim_tempo'[Data], -1, MONTH )",
              "            ),",
              "        ISINSCOPE ( 'dim_tempo'[DescricaoTrimestre] ) || ISINSCOPE ( 'dim_tempo'[IdTrimestre] ),",
              "            CALCULATE (",
              "                [Sellout],",
              "                DATEADD ( 'dim_tempo'[Data], -1, QUARTER )",
              "            ),",
              "        ISINSCOPE ( 'dim_tempo'[DescricaoSemestre] ) || ISINSCOPE ( 'dim_tempo'[IdSemestre] ),",
              "            CALCULATE (",
              "                [Sellout],",
              "                DATEADD ( 'dim_tempo'[Data], -2, QUARTER )",
              "            ),",
              "        ISINSCOPE ( 'dim_tempo'[IdAno] ),",
              "            CALCULATE (",
              "                [Sellout],",
              "                DATEADD ( 'dim_tempo'[Data], -1, YEAR )",
              "            )",
              "    )",
              "RETURN",
              "    IF (",
              "        NOT ISBLANK ( _curr ) && NOT ISBLANK ( _prev ),",
              "        VAR _perc = DIVIDE ( _curr, _prev ) - 1",
              "        RETURN",
              "            SWITCH (",
              "                TRUE,",
              "                _perc < -0.25, -2,",
              "                _perc < -0.05, -1,",
              "                _perc > 0.25, 2,",
              "                _perc > 0.05, 1,",
              "                0",
              "            )",
              "    )",
              "        "
            ]
          },
          "annotations": [
            {
              "name": "PBI_ChangedProperties",
              "value": "[\"FormatString\"]"
            }
          ]
        }
      ],
      "annotations": [
        {
          "name": "PBI_ResultType",
          "value": "Table"
        }
      ]
    }
  }
}

[MK-OS]

We are facing the same issue, model was up only after removing the KPI. 

[Anonymous]

Hi @AlessandroGAVB ,

Please provide us with your version of Power BI Desktop
I have not searched for this issue in the internal bug platform at the moment.
Is this problem still present after a few days?

Best regards.
Community Support Team_ Caitlyn

[ColleenL]

We are having the same issue and reported the bug on Friday on ticket 2212160040004617.

After initial call with support, indications were that the bug was a result of the update released on 12/15/2022

• Client version: 2212.1.11454-train
  Cluster URI: https://wabi-west-us-c-primary-redirect.analysis.windows.net/

• There were no changes to our environment/model/reporting
• Only model affected is one with KPIs
• We are able to access the model via excel with no error
• Unable to access via report in browser or PBI Desktop
• Model does load if KPIs removed from model (but all reporting depends on the KPIs so not a solution)
• Error Messager when Opening Report in browser:

Cannot load model Coudn't load the model schema associated with this report. 

Underlying Error: PowerBI service client received error HTTP response. HttpStatus: 400. PowerBIErrorCode: QueryUserError
QueryUserError: unsignedInt
Correlation ID: 50075276-c249-0d47-4e8e-b42ac9c37cfd
Activity ID: 3b20f944-7a00-4454-9737-72205b7087b3
Request ID: 6f7ceac4-05f5-6ffb-3f9e-5c6e75eb9d9e
Time: Sun Dec 18 2022 23:12:50 GMT-0500 (Eastern Standard Time)
Service version: 13.0.19635.59
Client version: 2212.1.11454-train
Cluster URI: https://wabi-west-us-c-primary-redirect.analysis.windows.net/

• Error when accessing the model from Power BI Desktop

Cannot load model We couldn't connect to your model in teh Power BI Service. The dataset may have been deleted, renamed, moved, or it is possible that you dn't have permission to access it. The '' string cannot be converted to the unsignedInt type.

[AlessandroGAVB]

Version: 2.112.603.0 64-bit (December 2022)

[ColleenL]

Hi AlessandroGAVB,

We were having the same issue as you with KPIs - also on same client version (updated on 12/15), same service version, same PBI desktop version.

As we were working with a MS engineer, the issue resolved itself. We are waiting for an RCA, but for now it seems to be fixed. You may want to check your reports as well.