Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Data from GA is incorrect

Hi community,   I am pulling data from GA into Power BI Desktop using the Power BI GA Connector.   However, when i pull in the data: Date, Hostname, Visitor Type (Hit), Sessions   ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi v-piga-msft,

     

    The solution for this issue is to go through BigQuery and pull the data into Power BI.

    From research, i believe that connecting from Power BI to BigQuery to pull in the Sessions, will remove the sampling mechanism from taking place and limiting the actual dataset.

     

    Thanks,

    Laz

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi Anonymous,

 

If I understand your issue correctly that when you get data with the Google Analytics conncetor, the data doesn;'t match the data in GA and the data is not related to the data you have edited in Query Editor?

 

If it is, I cannot reproduce your second issue in my site by my test.

 

For your first issue, I'm afraid that may caused by Google Analytics connector, please refer to this similar thread.

 

Best  Regards,

Cherry

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi v-piga-msft,

     

    The solution for this issue is to go through BigQuery and pull the data into Power BI.

    From research, i believe that connecting from Power BI to BigQuery to pull in the Sessions, will remove the sampling mechanism from taking place and limiting the actual dataset.

     

    Thanks,

    Laz

    • v-piga-msft's avatar
      v-piga-msft
      Resident Rockstar
      7 years ago

      Hi Anonymous,

       

      It seems that you have solved your problem.

       

      If it is, please accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

       

      Best  Regards,

      Cherry