Forum Discussion
Power Bi: Google Analytics
I have been trying to set up Google Analytics as a data-source for my PBi Report but my Report on Google Analytics has a date range which is showing last weeks data.
- If i set the data range on GA does it go over to PBi in Real Time? So that whatever changes i make to the date range, the PBi report will change as well when i hit refresh.
- What do i have to do in order to show the data from the last week?
There is no date column on GA, i have never used GA, i have just been given this task to make a report automated and to pull data from different sources.
paulfink ,
You can use relative slicer to filter the last week of the date from GA. For more details, please refer to doc below:
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
If you pull data from GA into Power BI it should pull all of the underlying data that exists regardless of what a report in GA is showing.
That makes sense, thank you Greg.
How do i show the last week of data then? There is no date column on GA.
paulfink ,
You can use relative slicer to filter the last week of the date from GA. For more details, please refer to doc below:
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
