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
haydenDMS
New Member

Inconsistent Data from Google Analytics

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 

61798e38-62bb-417b-a888-a596d0b2af0c.png

Screenshot (39).png

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. 

0 REPLIES 0

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

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.