Forum Discussion

graphman's avatar
graphman
Regular Visitor
8 years ago

Hive table ODBC data not cached in powerBI

My setup: PowerBI Desktop connecting to Hiveserver2 using Hortonworks ODBC driver   Issue: When I issue "Get Data" and load a Hive table, PowerBI loads all data from the table. Since DirectQuery is...
Need Help
v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

graphman

 

In Power Query, once you make changes which will add steps, it will execute entire Power Query when you "Save & Close" Query Editor. That's the reason why it will re-import the table. 

 

Regards,

  • graphman's avatar
    graphman
    Regular Visitor
    8 years ago

    Hi Simon,

     

    Thanks for the answer.

     

    If PBI is creating the new column through a HS2 query, then we can definitely see the rationale.

     

    But it looks like a regular import of the entire table again – which hardly serves any purpose. It hurts when we work on a high-latency line.

    (or)

    Am I missing something here?

     

    Thanks, 

    Best,

    Graphman