Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Rest API Google Analytics connection failed in Dataflows

Hi!

I am connecting to Google Analytics via rest API. I have followed the steps and code shared in this GitHub  @MAXIM_UVAROV . 

 

Whereas in PowerBI Desktop works fine, when i try to get refresh token in Dataflows it always  fails. I guess something is failing with the function Web.Contents ()  but I am not sure. Any help would be really appreciated.

 

This is my code:

 

let
    app_credentials = "client_id=xxxxxxxxxxxxx.apps.googleusercontent.com&client_secret=xxxxxxxxxxx",
   code = "code=" & authToken,
   url = code & "&" & app_credentials & "&redirect_uri=urn:ietf:wg:oauth:2.0:oob&grant_type=authorization_code",
   GetJson = Web.Contents("https://accounts.google.com",
              [
                     RelativePath = "/o/oauth2/token",
                     Headers = [#"Content-Type"="application/x-www-form-urlencoded"],
                     Content = Text.ToBinary(url),
                     ManualStatusHandling = {400}
              ]
   ),
   Json2 = Json.Document(GetJson),
   refreshTokenOutput = try Json2[refresh_token] otherwise Text.Combine({Json2[error]?, Json2[error_description]?, "Bad     authToken"}, " / ")

 

in
refreshTokenOutput

 

Thanks in advanced!

 

2 REPLIES 2
MAXIM_UVAROV
Frequent Visitor

Hey @Anonymous , sorry, haven't tried dataflows with google analytics yet. I'm not sure that I will be able to do that soon. But if I will - I'll let you know

Anonymous
Not applicable

Thank for your response @MAXIM_UVAROV 

 

I also wanted to thank you for sharing your custom connector script. It is awesome 🙂

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors