Error con el conector de GA

[jagutierrezm]

Tengo un reporte que usa el conector GA pero al actualizar el reporte me geners este error: 

DataFormat.Error: Se ha encontrado un carácter inesperado en la entrada JSON.
Detalles:
Value=\31
Position=0

este es el codigo del Query:

let
Origen = GoogleAnalytics.Accounts([Implementation="2.0"]),
#"Se expandió Data" = Table.ExpandTableColumn(Origen, "Data", {"Id", "Name", "Data", "Kind"}, {"Data.Id", "Data.Name", "Data.Data", "Data.Kind"}),
#"Filas filtradas" = Table.SelectRows(#"Se expandió Data", each ([Data.Name] = "manapro.com")),
#"Se expandió Data.Data1" = Table.ExpandTableColumn(#"Filas filtradas", "Data.Data", {"Id", "Name", "Data", "Kind"}, {"Data.Data.Id", "Data.Data.Name", "Data.Data.Data", "Data.Data.Kind"}),
#"Data Data Data" = #"Se expandió Data.Data1"{0}[Data.Data.Data],
#"Elementos agregados" = Cube.Transform(#"Data Data Data",
{
{Cube.AddAndExpandDimensionColumn, "country", {"country"}, {"country"}},

{Cube.AddMeasureColumn, "engagedSessions", "engagedSessions"}

})
in
#"Elementos agregados"

[v-pnaroju-msft]

Hi Jagutierrezm,

We are following up to see if your query has been resolved. Should you have identified a solution, we kindly request you to share it with the community to assist others facing similar issues.

If our response was helpful, please mark it as the accepted solution and provide kudos, as this helps the broader community.

Thank you.

[v-pnaroju-msft]

Hi jagutierrezm,

We wanted to check in regarding your query, as we have not heard back from you. If you have resolved the issue, sharing the solution with the community would be greatly appreciated and could help others encountering similar challenges.

If you found our response useful, kindly mark it as the accepted solution and provide kudos to guide other members.

Thank you.

[v-pnaroju-msft]

Hi  Jagutierrezm,

We have not received a response from you regarding the query and were following up to check if you have found a resolution. If you have identified a solution, we kindly request you to share it with the community, as it may be helpful to others facing a similar issue.

If you find the response helpful, please mark it as the accepted solution and provide kudos, as this will help other members with similar queries.

Thank you.

[v-pnaroju-msft · Accepted solution]

Hi @jagutierrezm,

We appreciate your query on the Microsoft Fabric Community Forum.

Based on your description, the issue appears to be related to JSON parsing, which may occur due to unexpected characters in the data being retrieved.

Please find below the suggested steps to troubleshoot and potentially resolve the issue:

1. Ensure that you are using the latest version of the GA (Google Analytics) connector, as newer versions often address such issues.
2. If the report retrieves a large amount of data, try limiting the results to a smaller subset and check if the issue persists. This can help identify whether the problem lies with specific records.
3. Clear any stored credentials or cache associated with the Google Analytics connection in Power BI Desktop, as this may resolve authentication-related issues.

Additionally, please refer to the following link for more information:
Power Query Google Analytics connector - Power Query | Microsoft Learn

You can check the similar post below, which might help resolve this issue:
Problem with GA4 2.0 connection - Microsoft Fabric Community

If you find this response helpful, we kindly request you to mark it as the accepted solution and provide kudos. This will assist other community members encountering similar queries.

Thank you.