googleanalytics/ga-dev-tools

Google Analytics 2.0 (Beta) Connector to Power BI Desktop issue

Opened this issue · 0 comments

LTL38 commented

What page is this happening on
It's happening when connecting to the API for data in Power BI Desktop (Power Query)

Describe the bug
It provides an error stating the following:

An error occurred in the ‘SeroVital_com - GA4’ query. DataFormat.Error: We found an unexpected character in the JSON input.
Details:
Value=\31
Position=0

This only happens sometimes, other times it works fine. The error states it's an issue with the data formatting, but when checking the JSON, there is no \31 in the JSON at all.

To Reproduce
Steps to reproduce the behavior:

  1. Open Power BI Destkop
  2. Get Data>Other Sources>Online Sources>Google Analytics> 2.0 (beta)> sign in> grab some dimensions and metrics
  3. Data either loads or doesn't.
  4. Error will pop up.

Screenshots
image

Desktop (please complete the following information):

  • OS: windows]
  • Power BI Desktop
  • Version 2.137.1102.0 (October 2024)