Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |