Getting Error while refreshing Google Analytics Data

[Gaurav_Lakhotia]

Hi All,

I'm getting OLE DB or ODBC Error while refreshing Google Analytics data. Data type of columns are correct.

I'm using the default connector for importing data to Power BI. Also suggest some alternative options to import Google Analytics Data to Power BI. 

Please help me out.

[v-eachen-msft]

Hi @Gaurav_Lakhotia ,

In your scenario, when the error throws occurs, please access Google Analytics to check if the issue is occurring on Google Analytics side. Also please use Fiddler to monitor traffic between Power BI and Google Analytics, check if you can find any useful information. You can enable tracing on Power BI Desktop to find what's happening: Power BI Desktop Trace Logs Analyser.

[amitchandak]

@Gaurav_Lakhotia , refer if this can help

https://community.powerbi.com/t5/Desktop/Error-refreshing-google-analytics-data/m-p/898068

or

Refer:https://community.powerbi.com/t5/Service/Google-Analytics-Authentication-Error-App-not-verified-by-G...

https://community.powerbi.com/t5/Desktop/Google-Analytics-error-connection-impossible-modify/m-p/882...

https://community.powerbi.com/t5/Desktop/Error-connecting-Google-Analytics-and-Power-Bi/m-p/782185

[Gaurav_Lakhotia]

Hi @amitchandak , Thank you for the reply, but this is not the one, I'm looking for.

[amitchandak]

@Gaurav_Lakhotia , Clear permission, and try again. This related to access.

[Gaurav_Lakhotia]

still facing same issue.