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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
croberts21
Responsive Resident
Responsive Resident

Use SQL Statement as a data source because it's 10x faster.

Power BI desktop can be very slow over an ODBC connection with Postgresql. It can get an out of memory error or use a lot of resources. It can take 10-20 minutes or more to get data from one table with millions of records. Here's a fast way to limit the records and skip the Transform step which can be very time-consuming. Use an SQL statement as the data source.

 

  1. Go to Home tab bar.
  2. Choose Get Data dropdown and click More.
  3. Search for ODBC and choose ODBC. Click Connect button.
  4. A window will pop up. Click arrow on Advanced Options.
  5. Enter your SQL statement in the "SQL Statement" box.

 

To edit the SQL statement:

  1. On the far right of PBI, under the Fields pane, right click the table, choose Edit Query.
  2. A Power Query Editor window will pop up.
  3. On the far right, under Applied Steps, double click Source.
  4. Another window will pop up with your SQL statement which you can edit.
  5. After editing the SQL click the OK button.
  6. Now you are back to the Power Query editor. In the upper left of the window click Close & Apply.

Thanks for all your help people! I hope this helps someone. 

 

1 REPLY 1
v-jingzhang
Community Support
Community Support

Hi @croberts21 

 

Thanks for sharing!

 

Best Regards,
Community Support Team _ Jing

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.