Problem importing data from Google Analytics

[tomimu]

I'm trying to import website tracking data from GA to Power BI Desktop (tabs like Date, City, Country, Latitude, Longitude, Users etc.). The problem arises immediately as I choose Social Network and Action tab and it seems like it's filtering the dataset by itself. There's left only about 18 rows of data after I added the Social Network and Action tab. Can't find the solution anywhere...

-Tomi

[v-qiuyu-msft]

Hi @tomimu,

In your scenario, as you select the Social Network and Social Action dimensions, measure will return values sliced by those two dimensions. See: Social Interactions - Dimensions & Metrics Explorer.

As Google Analytics connector relies on Google Analytics Core Reporting API, you can try to run the latest desktop version to keep up with the API change. Also you can post a thread here to consult if API returns results correctly.

Best Regards,
Qiuyun Yu