QlikSense reload returning '0 lines fetched' from Databricks tables

[Karim_Khan]

Hi Team,

We are facing an issue while pulling data from one of the Databricks tables into QlikSense:

• A layer table: ~2.3M records (Table A)
• B layer table: ~560K records (Table B)

After reloading the QlikSense app, the load log shows '0 lines fetched' for both tables. We have already tried the following:

1. Verified that the source tables exist and their record counts in databricks(A~2.3M, B~560K).
2. Attempted to load both A and B layers separately to rule out transform issues.
3. Checked QlikSense data connection credentials and tested connectivity — connection tests succeed.

We can successfully fetch data when selecting a single column from [table_name]. However, queries that request multiple columns return zero rows.

SELECT 

*

FROM `A`;

[daudballing]

Hi,

Declare all your fields instead of using SELECT *.

Use the Qlik Sense data/table loading tool to select the fields you need as the field names will be imported with either backtick (`) or without.

The connection between Qlik Sense and Databricks seems to be sensitive to specifying field names and not use SELECT *.

[Karim_Khan]

Thanks ,

I tried with declaring all fields but still it got failed.It seems to be data formating/Qlik connector issue will check at DB level.