cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
judy_fmf
Helper I
Helper I

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 @judy_fmf , 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

Thank for your response @MAXIM_UVAROV 

 

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

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors