Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now

ann_ng

GA4 Index and length must refer to a location within the string. Parameter name: length

Submitted by on ‎12-10-2023 11:16 PM

I could not import the data from Google Analytics due to this error:

ann_ng_0-1702278849927.png

 

The data still get updated in Edit query but I could not load it to my report. How can I fix this?

 

Status: Accepted
See more ideas labeled with:
20 Comments (20 New)
Comments
alex0509
New Member
‎12-11-2023 12:25 PM

Having similar issue with GA4 connector. I'm able to load, but throws 'Length must refer to location in string' error when performing Remove Duplicates step in Power Query. 

Anonymous
Not applicable
‎12-11-2023 05:33 PM

Hi  @ann_ng 

Were you able to load data from Google Analytics properly before? If so, have you done any updates recently? What version of Desktop are you currently using to load the data that is reporting errors?

 

Best Regards,
Community Support Team _ Ailsa Tao

ann_ng
Regular Visitor
‎12-11-2023 06:53 PM

@Anonymous Yes. I was doing good with my reports and suddenly on last Wed to Thursday, I was unable to load the data with the above issue.

 

I updated the Power Bi Desktop to the latest version. But I tried to delete the app and install the older version, nothing changed.

 

I'm currently using Power BI Desktop Version: 2.123.742.0 64-bit (November 2023).

 

jfajerwerg
Regular Visitor
‎12-11-2023 07:34 PM

Hi there,

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

Please let me know if you need more information.
I use 2.0 connector for GA4. it works if i try to load data with some other dimensions such as date, session, engagedSession, pagePath.

I have the issue both on Power BI Service using Dataflows Gen1, Gen2 and Power BI Desktop x64 (Version: 2.123.742.0 64-bit (November 2023))
 
On PBI Service, the error after 5 to 15 seconds is "Error: PipelineException: Index and length must refer to a location within the string."
JesTay97
Regular Visitor
‎12-11-2023 08:25 PM

I am also getting this!

 

need a way to get around an drefresh the report.

ann_ng
Regular Visitor
‎12-11-2023 11:16 PM

@AnonymousI am creating a different dataset named Analytics Report2 in the photo below. And it can load data to my report before I add: firstUserCampaignName, firstUserDefaultChannelGroup, firstUserMedium, firstUserSource. I think I might continue to work with my report without these dimensions.

 

The Analytics Report is the one couldn't load with the issue above.

ann_ng_1-1702365128745.png

 

jfajerwerg
Regular Visitor
‎12-12-2023 06:12 PM

@Anonymous Hello, what is the status of this issue today? This topic seems to be on "Needs info". Please let us know if you need more information. Thank you for your assistance! 

kletterbilder
Helper I
Helper I
‎12-13-2023 06:14 AM

Hi, 

 

I have the same problem. I figured out following problems. I checked each field one by one and found out the all field with Medium are not working right now. I need this informations back in my report. Who can help us?

 

Here my overview. After the "//" you will find if it is working or not.

 

{Cube.AddAndExpandDimensionColumn, "date", {"date"}, {"date"}},                                                    //is working
{Cube.AddAndExpandDimensionColumn, "isoWeek", {"isoWeek"}, {"isoWeek"}},                                           //is working
{Cube.AddAndExpandDimensionColumn, "isoYear", {"isoYear"}, {"isoYear"}},                                           //is working
{Cube.AddAndExpandDimensionColumn, "pagePath", {"pagePath"}, {"pagePath"}},                                        //is working
//{Cube.AddAndExpandDimensionColumn, "sourceMedium", {"sourceMedium"}, {"sourceMedium"}},                              //not working
//{Cube.AddAndExpandDimensionColumn, "sessionMedium", {"sessionMedium"}, {"sessionMedium"}},                           //not working
//{Cube.AddAndExpandDimensionColumn, "medium", {"medium"}, {"medium"}},                                                //not working
//{Cube.AddAndExpandDimensionColumn, "firstUserMedium", {"firstUserMedium"}, {"firstUserMedium"}},                     //not working
//{Cube.AddAndExpandDimensionColumn, "firstUserSourceMedium", {"firstUserSourceMedium"}, {"firstUserSourceMedium"}},   //not working
//{Cube.AddAndExpandDimensionColumn, "sessionSourceMedium", {"sessionSourceMedium"}, {"sessionSourceMedium"}},         //not working
//{Cube.AddAndExpandDimensionColumn, "sessionSa360Medium", {"sessionSa360Medium"}, {"sessionSa360Medium"}},            //working - but empty
{Cube.AddAndExpandDimensionColumn, "source", {"source"}, {"source"}},                                              //is working
{Cube.AddMeasureColumn, "totalUsers", "totalUsers"}                                                                //is working

 

 

Anonymous
Not applicable
‎12-13-2023 09:34 AM

Hello, @v-yetao1-msft I'm also having the same issue with the GA4 connector. I'm unable to refresh the data in my reports.

 

This is the error meesage I receive: 

Index and length must refer to a location within the string.
Parameter name: length

Microsoft.Mashup.Evaluator.Interface.ErrorException

True

 

I've copied the details below.

 

 

Feedback Type:
Frown (Error)

Timestamp:
2023-12-13T17:26:02.6778908Z

Release:
November 2023

Product Version:
2.123.742.0 (23.11) (x64)

Stack Trace:
Microsoft.Mashup.Host.Document.SerializedException
at Microsoft.Mashup.Evaluator.EvaluationHost.OnException(IEngineHost engineHost, IMessageChannel channel, ExceptionMessage message)
at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.Interface.IMessageChannelExtensions.WaitFor[T](IMessageChannel channel)
at Microsoft.Mashup.Evaluator.MessageBasedInputStream.ReadNextChunkAndCheckIfClosed()
at Microsoft.Mashup.Evaluator.MessageBasedInputStream.ReadNextChunk()
at Microsoft.Mashup.Common.ChunkedInputStream.Read(Byte[] buffer, Int32 offset, Int32 count)
at Microsoft.OleDb.Serialization.PageReader.Read(Byte[] buffer, Int32 offset, Int32 count)
at Microsoft.OleDb.Serialization.PageReader.ReadChars(Int32 count)
at Microsoft.OleDb.Serialization.PageReader.ReadArray(String[] values, Int32 offset, Int32 count)
at Microsoft.OleDb.NullableColumn.Deserialize(PageReader reader)
at Microsoft.OleDb.Serialization.ColumnsPage.Deserialize(PageReader reader)
at Microsoft.OleDb.Serialization.OleDbPageReader.Read(ColumnsPage page)
at Microsoft.Mashup.Common.IPageReaderExtensions.NotifyingPageReader.Read(IPage page)
at Microsoft.Mashup.Engine.Interface.Tracing.TracingPageReader.Read(IPage page)
at Microsoft.Mashup.Evaluator.SoftCancellingDocumentEvaluator.DataReaderSourceEvaluation.SoftCancellingDataReaderSource.SoftCancellingPageReader.Read(IPage page)
at Microsoft.Mashup.OleDbProvider.DataHost.NonBufferingMashupEvaluator.MashupEvaluation.ExceptionResolverPageReader.Read(IPage page)
at Microsoft.Mashup.Common.IPageReaderExtensions.NotifyingEndOfAllResultsPageReader.Read(IPage page)
at Microsoft.Mashup.Engine.Interface.Tracing.TracingPageReader.Read(IPage page)
at Microsoft.Mashup.Common.IPageReaderExtensions.NotifyingEndOfAllResultsPageReader.Read(IPage page)
at Microsoft.OleDb.Serialization.PageReaderRowset.ReadNextPage()
at Microsoft.OleDb.Serialization.PageReaderRowset.Microsoft.OleDb.IRowset.GetNextRows(HCHAPTER hchapter, DBROWOFFSET lRowsOffset, DBROWCOUNT cRows, DBCOUNTITEM& countRowsObtained, HROW** pRows)
at Microsoft.OleDb.Rowset.Microsoft.OleDb.IRowset.GetNextRows(HCHAPTER hReserved, DBROWOFFSET lRowsOffset, DBROWCOUNT cRows, DBCOUNTITEM& countRowsObtained, HROW** pRows)
at Microsoft.Mashup.OleDbProvider.TracingRowset.Microsoft.OleDb.IRowset.GetNextRows(HCHAPTER hReserved, DBROWOFFSET lRowsOffset, DBROWCOUNT cRows, DBCOUNTITEM& countRowsObtained, HROW** pRows)

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.123.742.0","ModuleName":"","Component":"Microsoft.Mashup.Evaluator.EvaluationHost","Error":"Microsoft.Mashup.Host.Document.SerializedException - Microsoft.Mashup.Evaluator.Interface.ErrorException","MethodDef":"OnException","ErrorOffset":"","ErrorCode":""}

 

 

jfajerwerg
Regular Visitor
‎12-13-2023 06:34 PM

To everyone who is facing the same issue, please upvote the original post by hitting the like button, so we can capture Microsoft's interest.

Idea Statuses