Data is not consistent

[haydenDMS]

I have pulled from the same data source into several different data tables (main quiery tables) and have displayed this data into report tables. 

When I first did this I pulled all the metrics and dimensions I planned to use from Google Analytics into one data table in power bi. But it was brought to my attention that this could cause some of the metrics/dimensions to be inflated (have multiple lines of the same data).

So my plan was to test this by created several data tables with just a few metrics and then create relationships and avoid the duplicate data issue. But when I did this the data I got was not constistent. 

The first report from a data table with several metrics/dimentinos 

breaking down the metrics into smaller tabels

The first table shows the data when I pulled all the metrics and dimentions into one large data table. 

The second shows where I pulled in a table focused on total users with date, sessions, pagePath, totalUsers.

Another data table focused on new users with date, sessions, pagePath, newUsers.

Then ended up adding one with both to compare becasue the numbers were not matching up.

Can anyone explain why these have different numbers. I expected these all to be the same. 

[CoderZen08]

Hi @haydenDMS As other comment mentioned, is important you always query exact same fields on GA4 scope so numbers will match. As a workaround, maybe you can try to test your connection with a 3rd party tool. I currently user windsor.ai's GA4 connector and I haven't had any mismatch problem but always comparing same fields versus what I select on my GA4 scope. 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 GA4 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. 

[jennratten]

The metrics can return different result based on the scope at the time the data is queried (aka the other measures and dimensions that are included in the same query).  Some measures also include values of other measures.

This is a list of all the measures and dimensions with their explanations.

[haydenDMS]

How do I enusre I am getting the most correct and accurate data?