Forum Discussion
Google Analytics Complete Connector
HI Lino,
Why you not use official method to export google analytics data? For power bi connectors, it may not similar as the original one.(it may contains some modifies or other operations to improve compatibility)
In addition, you can also try to use odata connector to connect to google analysis API.
Regards,
Xiaoxin Sheng
Hello v-shex-msft
Thanks for your reply.
The official method could be a solution by creating an ETL process behind, but I am trying to exctract directly data using Power BI.
Using M Language, my scope would be:
- Getting Authorization Code using https://accounts.google.com/o/oauth2/v2/auth.
- Using Authorization Code, getting Token using https://accounts.google.com/o/oauth2/token.
- Using Token, getting data from Google Analytics using Analytics API.
It works creating a Custom Connector via Visual Studio, but it does not work in Power BI Service, since I cannot use custom connectors there. Therefore, I am trying to create the same logic using M language directly in Power BI Desktop.
My first issue is getting Authorization Code using Web.Contents function. This function returns the correct page that includes the Code parameter as response inside of the URL.
Now, how can I get a parameter inside of an URL using M language?
Regards
Lino
HI Lino,
You can take a look at below link:
authenticating with Excel Power Query against .Net Odata Web Api
BTW, current custom power query functions only available on desktop side.
Regards,
Xiaoxin Sheng
Hi Anonymous
Thanks a lot for your suggestion, but I used GoogleAnalytics.Accounts() built-in function and everything is working with both the Desktop and the Service version.
Unfortunately, I cannot set filters before the extractions, but at the moment I am not encountering issues.
Regards
Lino
I want to rectify. Unfortunately, the built-in Google Analytics connector does not work correctly, and therefore I opened this discussion.