Google analytics Source_gatewayError

[Anonymous]

Hi,

 I have a Power BI report that uses Google analytics as the source. However, while I can refresh the data from PowerBi desktop with no issues at all, Power BI service is not allowing the gateway to refresh data and displaying the following error:

Underlying error code: -2147467259
Underlying error message: Native queries aren't supported by this value.
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.ValueError.Detail: #table({"Name", "Data", "Schema", "Item", "Kind"}, {})
Microsoft.Data.Mashup.ValueError.Reason: Expression.Error
Cluster URI: WABI-WEST-US-redirect.analysis.windows.net
Activity ID: 2882821f-dbe3-4462-ae0e-56cca4165f56
Request ID: 638d0e1a-eb7e-87ac-466e-9cd7c274bf46
Time: 2021-02-15 19:58:24Z

I do have a natie query inside the report which write backs to SQL server DB as "Insert Into" statement

Any help!

Thanks

[Anonymous]

Hi @Anonymous ,

Does your data source have only one Google analytics? If you have SQL server or other data sources, you need to configure the gateway.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.