Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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

Need Help

9 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ,

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      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

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      nope, sadly not.

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    2 years ago

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

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    2 years ago

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

  • ankitajaiswal's avatar
    ankitajaiswal
    Regular Visitor
    2 years ago

    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.

  • QueryWhiz's avatar
    QueryWhiz
    Post Patron
    2 years ago

    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.