Forum Discussion
Google Analytics connector missing startdate/enddate parameters
I thought this had been asked before, but I didn't find a thread via search. A GA connection has a query pattern like so: let
Source = GoogleAnalytics.Accounts(),
account = Source{[Id="6...
intrasight, interesting. I'm not very familier with GA's API, I can talk to the dev who worked on this. Particularly, I'm a bit surprised that the inclusion of Date dimension breaks the aggregation on GA.
PowerQuery's multidimensional model had limited support for additional parameters to the cube. We've only began adding it for SAP and AS. So for the GA connector, the start/end date parameter is automatically populated via the filter on date dimension. I think there's could be a bug in the PowerQuery folding logic, when the date dimension is collapsed, we should not have sent &dimension=ga:date.
I'll follow up on this and get back to you.