Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

0

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

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

 

AaronApexPeak_0-1662041546903.png

 

 

 

 

 

 

 

Status: Delivered

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

 

Comments
v-yingjl
Community Support
Status changed to: Delivered

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

 

AaronApexPeak
Frequent Visitor

@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?

 

 

AaronApexPeak_1-1663278735291.png