Forum Discussion
Incremental Refresh for Google Analytics
Hello Everyone.
I cant seem to implement Incremental Refresh on my Google Analytics tables.
Anyone know why this is?
7 Replies
Anonymous great question. Did you read about an incremental refresh? If yes what and where you think things are failing?
Anonymous , refer if these can help
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-mashup-on-premises-cloud
Or
https://sqldusty.com/2020/05/20/power-bi-incremental-refresh-with-web-api-data-source/
https://radacad.com/all-you-need-to-know-about-the-incremental-refresh-in-power-bi-load-changes-only
Or
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/
Hi Anonymous ,
Have you set the parameters?
RangeStart and RangeEnd parameters
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Your parameters seem to be configured incorrectly.
The names of these two parameters are fixed, and the data type must be a date/time type.
Please check the parameters again.
In addition, Google Analytics does not need to add a gateway because it is a cloud data source.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous - did you ever get this working?
When I look at my Google Analytics queries, and right click on one of the 'steps' - "Native Query" option is greyed out, which typically means that it doesn't support query folding / therefore incremental refreshes. But if you did get it working, I would love to hear!
