Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
TMason
Frequent Visitor

PowerBi Ga4 connector

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

1 ACCEPTED SOLUTION
v-cgao-msft
Community Support
Community Support

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

View solution in original post

9 REPLIES 9
QueryWhiz
Helper V
Helper V

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:

 

GA4-1.png

 

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:

 

GA4-2.png

 

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. 

 

SELECT_DESTINATION_NEW.png

ankitajaiswal
Regular Visitor

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
Community Support
Community Support

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

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
Administrator
Administrator

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

Syndicate_Admin
Administrator
Administrator

@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
Administrator
Administrator

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

Syndicate_Admin
Administrator
Administrator

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

nope, sadly not.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors