cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
croberts21
Post Patron
Post Patron

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
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors