Forum Discussion
HIVE tables as data source
Im using HIVE tables from HDInsight Cluster as my source using (HDInsight Interactive Query to connect to the source). The tables have huge data more than 5 million rows. When using direct query, it'...
Why are you not using Import then? Direct Query has its limitations, performance and reduced data model functionality.
You can summarize or filter data inside Power Query before it gets to the data model if you don't want the millions of records in there at the lowest level of granularity.