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.
We are attempting to import data from hive on to a data model in PowerBI desktop. There are about 5 million records and this takes almost 1.5 hours to load. When we look into the SQL profiler results, the reading of data from the table in hive seems to be taking up a lot of the time - about 85 minutes. The compression steps are only a few minutes in total. How do we troubleshoot this further to understand where the bottleneck is? Are there any settings we should be checking on at hive end or powerBI end or in the driver that could improve this load time?
Hi @MATH2020 ,
You could turn off the option in the settings dialog:
Options->Current File->Data Load->Auto Date/Time
Hi @MATH2020 ,
Has your problem been solved? Was my reply helpful to you? If the problem is resolved, you could accept the reply you like.
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 |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |