Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I"m using Remote Desktop on Windows to get to a computer that has Power BI on it. PBI connects to a Postgresql database via ODBC. One of the other guys who use PBI got advice from Microsoft to use ODBC with Postgresql. I'm trying to connect to one of the tables for the first time on this machine. It's a small table with, at most, 1000 records. And the "Preview is evaluating" has been going on for 15+ minutes.
The computer running PBI has a hard drive, which means, PBI can be slow. But I didn't know it was this slow. Other uses may RDP into this machine and might be using it also. The other person who uses PBI is not available for me to ask questions.
Is this normal for other databases? Is it normal for ODBC or Postgresql?
I'd be interested in any suggestions you may have for me.
Thanks!
Solved! Go to Solution.
Hi @croberts21 ,
You can refer the following documentations to connect to PostgreSQL by using PostgreSQL or ODBC connector:
PostgreSQL To Power BI: 3 Best Ways To Connect
Connecting PostgreSQL to PowerBI
If you connect to PostgreSQL with import connectivity mode, please select the SQL statement field under Advanced options, and paste or enter your native database query just as below screenshot. Later check whether the table can be loaded faster...
And please check the setting of the following options:
1. File--> Options --> Background Data
2. File--> Options --> Preview features
Best Regards
Hi @croberts21 ,
You can refer the following documentations to connect to PostgreSQL by using PostgreSQL or ODBC connector:
PostgreSQL To Power BI: 3 Best Ways To Connect
Connecting PostgreSQL to PowerBI
If you connect to PostgreSQL with import connectivity mode, please select the SQL statement field under Advanced options, and paste or enter your native database query just as below screenshot. Later check whether the table can be loaded faster...
And please check the setting of the following options:
1. File--> Options --> Background Data
2. File--> Options --> Preview features
Best Regards
Thank you. I'm having more problems with connecting to some tables in our db and not others. How do I find out what our native database query would be for connecting to Postgresql via ODBC? Neither me nor the IT peope would know this. Our IT department is responsible for configuring this, I'm just a user.
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |