Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Google Analytics 2.0: Desktop vs Service issue

Hi,

 

I'm using the Google Analytics 2.0 (GA4) connector to gather data.

The first Query I launched had only a dimension (Date) and a metric (Sessions) and it worked.

 

Then I tried a more complex Query, involving 3 dimensions (Date, PagePath and DeviceCategory) and a metric (Sessions). 

There, it happened that when calling for data in the Power BI Desktop, the Query has been loading for 5 hours before I cancelled it manually.

On the other hand, the same Query in Power BI Service retrieved data in few seconds.

 

Moreover, analyzing data through Power Query Editor in both scenarios, over the same Query, I've noticed that:

- in Power BI Desktop, the count of the rows computed with M would have been around 13'000 rows.

- in Power BI Service, the output stores around 2'000 rows (that's the 15% !!)

 

The query I'm writing in M is the following one:

 

Cube.Transform([PreviousStep], {{Cube.AddMeasureColumn, "sessions", "sessions"},
                         {Cube.AddAndExpandDimensionColumn, "date", {"date"}, {"date"}},
                         {Cube.AddAndExpandDimensionColumn, "pagePath", {"pagePath"}, {"pagePath"}},
                         {Cube.AddAndExpandDimensionColumn, "deviceCategory", {"deviceCategory"}, {"deviceCategory"}}
                         })
 
I've searched online for some documentation about it but didn't find anything that suites;
can someone help me in understanding why it happens and how to solve it?
 
Thanks to all!
Need Help

1 Reply

  • ReportBuilder07's avatar
    ReportBuilder07
    Helper III
    2 years ago

    Hi Anonymous Seems like the 2.0 beta connector is still presenting some issues. As a workaround, maybe you can try to test your connection with a 3rd party tool. I've tried windsor.ai, supemetrics and funnel.io. I stayed with windsor because it is much cheaper so just to let you know other options. In case you wonder, to make the connection first search for the GA4 connector in the data sources list:

     

     

    After that, just grant access to your GA4 account using your credentials, then on preview and destination page you will see a preview of your G4 fields:

     

     

    There just select the fields you need. Finally, just select PBI as your data destination and finally just copy and paste the url on PBI --> Get Data --> Web --> Paste the url.