Forum Discussion

intrasight's avatar
intrasight
Helper IV
10 years ago

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...
Need Help
Framet's avatar
Framet
Resolver II
9 years ago

Hi,

 

It's a long shot but has anyone found a solution to this without using a third party service as an middle man?

I agree with the many other posts without being able to pass a date filter it is forcing sampling and redering the connector mostly useless. A number of posts across the Power BI forums confuse the issue and suggest post filtering.

 

So far my many attempts to work round the issue have failed. :(


Thanks

Thomas

intrasight's avatar
intrasight
Helper IV
9 years ago

Hi Thomas,

Microsoft did indicate in this tread that they were considering/planning to ad the start/end date parameters. Perhaps someone from Microsoft can chime in. I ended up proxying my requests through a middle-tier service to get what I wanted.

 - Chris

 

  • Jmenas's avatar
    Jmenas
    Advocate III
    8 years ago

    Hi intrasight

    Thanks for the post, somehow I started to have the same issue just a few days ago. Do you have any news about the fix or the workaround? 


    I have the same issue just with dates and E-Commerce data. Only that if I want the correct data as my Analytics UI I have to filter by weeks. :( 
    I don't know why the folding is so bad for the data for some properties and not for others. 

    Let me know if there is an Idea or a Bug issue to vote for. 

    Best,
    J.

  • intrasight's avatar
    intrasight
    Helper IV
    8 years ago

    I've not heard any updates on this. I assume it just not a high-priority item :(

  • SergBI's avatar
    SergBI
    Regular Visitor
    8 years ago

    Hey, Chris!

     

    I have also encountered the data sampling in Power BI.

     

    It even occurred within small projects because Power BI required data for the whole period.

     

    I have found the solution in creating our own connector that would divide queries by days and import them in the SQL Server Database. This way, we managed to solve the problem.

    Eventually, our solution escalated into a separate product. It is more convenient to work with one database which contains not only Google Analytics data, but other data as well. Such as data from Google AdWords and CRM systems.

     

    You can try to set up integration on our website.

     

    I am always there and happy to help if you have any questions.