PowerBi Ga4 connector

[TMason]

Hi, I'm trying to get the PowerBI Ga4 Connector to work and keep getting this error message when I press close and apply.
any ideas?

Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: Index and length must refer to a location within the string. Parameter name: length.

thanks

[QueryWhiz]

Hi, as a workaround, maybe you can try to test your connection with a 3rd party tool. I've tried windsor.ai, supemetrics and funnel.io. I stayed with windsor because it is much cheaper so just to let you know other options. In case you wonder, to make the connection first search for the GA4 connector in the data sources list:

After that, just grant access to your GA4 account using your credentials, then on preview and destination page you will see a preview of your GA4 fields:

There just select the fields you need. Finally, just select PBI as your data destination and finally just copy and paste the url on PBI --> Get Data --> Web --> Paste the url. 

[ankitajaiswal]

Please share the timeline of the resolution. I have been waiting for a very long time now. This issue has been blocking data refresh for about a month now.

[v-cgao-msft · Accepted solution]

Hi @TMason ,

This issue has been reported to the product team. The engineers have determined the cause of the problem. If there are any updates, I will reply here.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

[v-cgao-msft]

Hi all,

The information I am getting is that the issue is caused by the Google Analytics API returning bad records in the results. Engineers are working with Google to understand and escalate the issue to them.

You can also contact Google Support to bring it to their attention:
How to get support - Analytics Help (google.com)

Best Regards,
Gao
Community Support Team

[Syndicate_Admin]

Same issue! It seems it happens only when I use a dimension related to the session medium (so including sessionMedium, sessionSourceMedium, sessionDefaultChannelGroup).

[Syndicate_Admin]

@QuentinR @Syndicate_Admin I'm getting support here: GA4 Index and length must refer to a location with... - Microsoft Fabric Community

You guys can follow the link to get updates about the solution.

[Syndicate_Admin]

Same problem since the same date. Do you know an alternative connector ?
Could Microsoft support help us ?

[Syndicate_Admin]

I'm having the same issue. Have you found the way to fix this?

[TMason]

nope, sadly not.