Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

660420id

GA4 connector not refreshing data due to an unexpected character in the JSON input

Submitted by on ‎02-16-2024 08:49 AM

@v-yetao1-msft Can someone please help me resolve an issue I'm facing? I am using 2.0(Beta) GA4 connector. Sometimes the data gets refreshed but since last Saturday, I keep seeing this error:

DataFormat.Error: We found an unexpected character in the JSON input.
Details:
    Value=\31
    Position=0

I am taking data from different properities, all other properities are refreshing properly, but this is the problem with only one property having the most traffic. I've spent hours trying to fix this, and am now stuck until something gets resolved. This is critical to our business as our stakeholders check the data in the report on a weekly basis and without the data refreshing, we aren't able to make appropriate business decisions.

 

I'm currently on Version: 2.124.2028.0 64-bit (December 2023). Let me know what other details you need to diagnose and resolve this issue.

Status: Investigating

Hi  @660420id ,

 

Based on the error message you‘ve provided.There might be an extra character (like a comma or other symbol) in the JSON input that’s causing the error. You could try checking the JSON input in a text editor or JSON validator to see if there are any unexpected characters.
Some users have reported that reducing the amount of data being requested in each query can help. For example, one user resolved the issue by only pulling the past month’s worth of data and splitting that into multiple queries so that each request only asks for 5 days at a time.


You may also need to ensure that both Power BI Desktop and the Google Analytics connector are updated to the latest version.
If the issue persists, you might want to try using a different connector or tool to connect to GA4, such as Google BigQuery.

 

Best regards.
Community Support Team_Caitlyn

 

 

See more ideas labeled with:
4 Comments (4 New)
Comments
v-xiaoyan-msft
Community Support
Community Support
‎02-18-2024 10:31 PM
Status changed to: Investigating

Hi  @660420id ,

 

Based on the error message you‘ve provided.There might be an extra character (like a comma or other symbol) in the JSON input that’s causing the error. You could try checking the JSON input in a text editor or JSON validator to see if there are any unexpected characters.
Some users have reported that reducing the amount of data being requested in each query can help. For example, one user resolved the issue by only pulling the past month’s worth of data and splitting that into multiple queries so that each request only asks for 5 days at a time.


You may also need to ensure that both Power BI Desktop and the Google Analytics connector are updated to the latest version.
If the issue persists, you might want to try using a different connector or tool to connect to GA4, such as Google BigQuery.

 

Best regards.
Community Support Team_Caitlyn

 

 

Shabyman2
Frequent Visitor
‎05-08-2024 01:59 AM

Did you resolve this, the big concern for my company is the connector vs BG is that BG will not how unconsented session figures, so this is going to cause a huge change in sessions and conversions, which are heavy used metrics for budgeting, forecasting, marketing spend etc.

CoderZen08
Helper III
Helper III
‎05-18-2024 02:47 PM

Hi @660420id Seems like the 2.0 beta connector is still presenting some issues. I've had some issues with it as well. As a workaround, maybe you can try to test your connection with a 3rd party tool. I've tried windsor.ai, supemetrics and funnel.io. I stayed with windsor because it is much cheaper so just to let you know other options. In case you wonder, to make the connection first search for the GA4 connector in the data sources list:

 

GA4-1.png

 

After that, just grant access to your GA4 account using your credentials, then on preview and destination page you will see a preview of your GA4 fields:

 

GA4-2.png

 

There just select the fields you need. Finally, just select PBI as your data destination and finally just copy and paste the url on PBI --> Get Data --> Web --> Paste the url. 

 

SELECT_DESTINATION_NEW.png

Shabyman2
Frequent Visitor
‎05-20-2024 05:57 AM

I appreciate all the comments about using third party tools, but when a company pays near for capacity servers and has had the ability to use GA3 for years without an issue and with 6 weeks to go a GA4 connector is still in Beta, it is shocking to be told go pay more money to access your data using other tools.

Microsofts support had this to say after we raised a ticket with them:

"Thank you for your continued patience and cooperation. We appreciate the collaboration we’ve had so far and apologies for the delay in relaying the update.

 

We have received an update regarding the  Connector and have been informed that the general availability of Connector's 2.0  implementation is blocked by Google as their API is still in beta. Once it is updated then only PBI will be releasing its version.

 

 If you have any questions or need additional information in the meantime, please do not hesitate to reach out."

Which begs the question, how can other tools work fine with this API in beta, but powerbi's errors 9/10. This email is essentially, we don't know why, we can't tell you why and we don't know when it will be out of beta or even when then it might be ready outside. 

Idea Statuses