Forum Discussion
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 wor...
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
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 ?