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.
Solved! Go to 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
I'm facing similar issue. Did you found a solution for this?
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
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.
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
User | Count |
---|---|
241 | |
56 | |
49 | |
45 | |
44 |
User | Count |
---|---|
280 | |
211 | |
82 | |
76 | |
75 |