Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Filtering GA data that is pulled?

Hello,

 

I am very new to PowerBi, so please bear with me!

 

My organization has a premium GA account, but not sure if this makes any difference. But, basically, I am having trouble pulling data from GA based on date parameters.

 

For example, let's say I want a chart that looks at page views last 30 days by date. The only way I am able to do this is, is if I pull the date dimnesion out of GA (so I have many more rows than 30) along with the page views, and then after the fact filter on date. But is there any way to filter on date BEFORE I pull the data? 

 

Perhaps I need to change something in the Syntax? Or maybe the GA connector is not the best way to do this?

 

-Thank you!

1 REPLY 1
v-qiuyu-msft
Community Support
Community Support

Hi @Anonymous,

 

When we connect to Google Analytics, we need a Google Analytics account as data source credetial. The account is required. Please refer to this article: Third-party service: Google Analytics connector for Power BI Desktop .

 

In your scenairo, you can filter data in Query Editor before you load the data. Please refer to screenshots below:

 

a2.PNGa3.PNG

 

Please take a look at links below:

Query overview in Power BI Desktop

Shape and combine data in Power BI Desktop

 

If you have any question, please feel free to ask.

 

Best Regards,
Qiuyun Yu

 

 

 

 

 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.