"This table is empty" - Shows Headers but No Rows

[Jaf017]

I am importing data via a DB2 SQL Query, its a quite large dataset 7-10 million rows. When querying my SQL statement in another software I receive rows. However when I try to import into Power BI, I am returned with an empty table.

I've only experienced this issue with large datasets.

[OlafK]

I'm facing similar issue. Did you found a solution for this?

[v-yulgu-msft · Accepted solution]

Hi @Jaf017,

While the loaded table from DB2 shows empty in desktop, click the refresh button to see if it works. Besides, you could break the SQL Query into two, so that you load the large dataset 7-10 million rows with two steps, then, you could append the two queries in desktop.

Regards,

Yuliana Gu

[Jaf017]

I've tried refreshing the data, but it still didn't populate. Breaking the query in two is a great idea. I will try it out.