Forum Discussion

anilelmastasi's avatar
anilelmastasi
Super User
2 months ago
Solved

GA4 data source in Power BI suddenly failing with DataFormat.Error (unexpected character in JSON)

Hi everyone, I'm connecting to Google Analytics 4 (GA4) from Power BI Desktop, and this has been working without any issues until today. Starting today, every refresh/connection attempt fails with ...
Need Help
  • jgeddes's avatar
    jgeddes
    2 months ago

    Hi anilelmastasi .

    I received that same error on one of 4 GA4 based reports I currently have in the Service. 
    I downloaded the report back into Desktop to troubleshoot but couldn't reproduce the error. (Everything refreshed normal.) I published the refreshed report to the Service and then forced a refresh there too. That refresh worked as well. I am hoping it was just a transient issue. 

jgeddes's avatar
jgeddes
Super User
2 months ago

Hi anilelmastasi .

I received that same error on one of 4 GA4 based reports I currently have in the Service. 
I downloaded the report back into Desktop to troubleshoot but couldn't reproduce the error. (Everything refreshed normal.) I published the refreshed report to the Service and then forced a refresh there too. That refresh worked as well. I am hoping it was just a transient issue. 

anilelmastasi's avatar
anilelmastasi
Super User
2 months ago

Hello jgeddes ,

 

Fortunately, this was a temporary problem. Now it is working. The problem continued 5 hours and I didn't changed anything. Some of my friend who is specialist in GA says, when Google updating something sometime, api returns no data. Thank you.