Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

ODBC SQl Query Connection but No Data

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

Need Help

6 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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

      • vinayvascuri's avatar
        vinayvascuri
        Frequent Visitor
        1 year ago

        Hello Chris 
        How did you resolve this issue ? Same happening at my end when I connect DELTEK Cloud to Power BI. Only the Schema ( column headers) appear at our end and not the data ?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous ,

     

    Have you tried excute the same SQL in database? Is there any data?

     

    Best Regards,

    Jay

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hello Anonymous 

       

      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

  • ThomasMob's avatar
    ThomasMob
    New Member
    3 years ago

    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).