Forum Discussion

Jaf017's avatar
Jaf017
Icon for Advocate III rankAdvocate III
7 years ago
Solved

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

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 ...
  • v-yulgu-msft's avatar
    7 years ago

    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