Error with grouped rows in Query steps

[DemoFour]

Hi All,

I have a been using this report  to monitor the gateway Monitor and optimize on-premises data gateway performance | Microsoft Learn  and over the weekend since the gateway has been updated it is not working. 

The issue is on a step that counts rows in the table using Group Rows.  The error states that there are more columns in the result than expected. Details : Count = 7 

I have tried to debug, but cant see the problem!  Has anyone else seen similar issue?  

= Table.Group(#"Renamed Columns2", {"Index", "GatewayObjectId", "Source.Name", "RequestId", "QueryTrackingId", "QueryExecutionStartTimeUTC",  "QueryType", "QueryText"}, {{"Count", each Table.RowCount(_), type number}, {"DataSourceType", each Text.Combine([DataSource.kind],","), type text}, {"DataSource", each Text.Combine([DataSource.path],","), type text}})

I have tried to add a similar column, but it return the same error.  Any suggestions to debug please. 

UPDATE - it seams the error is in the DataSource.Kind field as the filter shows that there is an error of [DataFormat.Error] with the there are more columns in the result than expected message. 

[Anonymous]

Hi @DemoFour ,

Please first check if the data source path is correct:

For my environment, the path is the second:

In my case everything is fine.

My gateway version:

Note:

This feature is currently available only for the on-premises data gateway in the standard mode. It's not available for the personal mode.

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

[DemoFour]

Hi @Anonymous 

Thank you for the reply, I have checked the file folder source and this is the correct one as show in your picture.  I have checked the files on the local drive and this all is correct. 

The gate way is 3000178.9 (June 2023) Date Published 15.6.23 

My gateway is the latest version, can you please test if you get the same error, if you are on the latest version. 

The error is in the group row step 

 #"Changed Type" = Table.TransformColumnTypes(#"Grouped Rows",{{"Source.Name", type text}, {"GatewayObjectId", type text}, {"RequestId", type text}, {"DataSource", type text}, {"QueryTrackingId", type text}, {"QueryExecutionStartTimeUTC", type datetime}, {"QueryType", type text}, {"QueryText", type text}}, "en-us")

I can't read your full query.  

Thank you for your assistance.