Forum Discussion
Advocate IGoogle Analytics Connector : editing the data in Microsoft M
basrooz
I doubt this is possible. For those online service connectors, you cannot filter before importing, tGA does not have something like advanced option to use SQL statement for SQL Server.You may add filter in the code but I guess it is not what you are looking for. Check the replies:
powerbi - Apply filters to Google Analytics query URI in Power BI - Stack Overflow
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
basrooz
I doubt this is possible. For those online service connectors, you cannot filter before importing, tGA does not have something like advanced option to use SQL statement for SQL Server.
You may add filter in the code but I guess it is not what you are looking for. Check the replies:
powerbi - Apply filters to Google Analytics query URI in Power BI - Stack Overflow
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
Advocate IAnonymous Thanks for your reply. I was afraid that was the case as I have Googled for quite a while but haven't managed to find a solution. I guess the best way would be to move all the Google Analytics data into Bigquery and query it from there.
Thanks!
- ReportMaster
Post Partisan
Hi basrooz were you able to find a solution? As a workaround,maybe you can try to test your connection with a 3rd party connector. I currently use windsor.ai 's GA connector and I can filter my data on a 'preview' step by date range, fields or accounts, before exporting to PBI, and without using any messy M code or any SQL query. In case you wonder, to make the connection first search for the GA connector in the data sources list:
After that, just grant access to your GA account using your credentials, then on preview and destination page you will see a preview of your GA fields:
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.