Powe BI Desktop hangs on loading modal when a step is added to sort table by Timestamp column

[Anonymous]

Version: 2.108.997.0 64-bit (August 2022)
I have a table of time series data with only 1.2m rows that hangs on the loading modal after getting all the rows from the database whenever I add a step to sort by the timestamp column. I have let it run several hours with no change.  Without the sort step, the data is loaded normally. I have reproduced this issue on the following variations:
- Different machine
- Different Postgres database (same data set)
- Importing data from csv instead of Postgres

[v-yingjl]

When connecting to a database, each time you add a step in Power Query editor, the query will be sent to the data source, if the data size is large, consider using Direct Query mode that PostgreSQL supports in Power BI Desktop, see:

Using DirectQuery in Power BI - Power BI | Microsoft Docs

Best Regards,
Community Support Team _ Yingjie Li

[Anonymous]

@v-yingjl I tried this option and the majority of Power Bi features do not work in this mode.  Even something basic like changing the type on the column forces you to switch to Import.  Can we please reopen this issue?