Forum Discussion

DemoFour's avatar
DemoFour
Continued Contributor
3 years ago

Error with grouped rows in Query steps

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

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's avatar
    DemoFour
    Continued Contributor
    3 years ago

    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.