Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
Due to the system limitations, I am only able to use a SQL query with ODBC to connect to the data table. However, only the columns pull and no data generates. Freshing the data doesn't work, reestablishing the connection doesn't work, changing the ODBC bit connection doesn't work, and if I try without the SQL query nothing works. Am I missing something in the query to get the data to populate?
= Odbc.Query("dsn=PostgreSQL35W", "SELECT * FROM schema.table WHERE 'reporting_quarter_445' IN ('2018-Q1','2018-Q2','2018-Q3','2018-Q4','2019-Q1','2019-Q2','2019-Q3','2019-Q4','2020-Q1','2020-Q2','2020-Q3','2020-Q4','2021-Q1','2021-Q2','2021-Q3','2021-Q4')")
Thanks!
-Christopher
Was the solution found?
I have the kind of the same problem:
ODBC connection does work, only the tables/data is not loading.
(to make it even more strange: if I put the datagateway on my personal computer (same netwerk, same settup) everything works well).
Hi @Anonymous ,
Have you tried excute the same SQL in database? Is there any data?
Best Regards,
Jay
Hello @v-jayw-msft
Thank you for reaching out! Unfortunately, the IT team whom I work with has stated to access the data it is supposed to be the ODBC.
Edit: The reason for ODBC is because the database is Greenplum based.
Thanks!
-Chris
@Anonymous , I think you have mention Query in advance Property.
Good Day @amitchandak ,
You are correct. The Query is in the advance property, but there is no data in the results. I can get a connection and the columns to populate, but none of the information.
Below is a screenshot of the advanced options filled out, as you have shown:
Below is the query showing the columns, but no information in the table (even though there is in the system):
Thanks!
-Chris
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |