Combining refresh and real time with Hybrid Tables in Power BI

Tired of having to wait for the next refresh to see current data in your Power BI Report? Hybrid Tables is here to help you! Patrick looks at how you can use this feature to have an imported table that uses DirectQuery for the most recent data that hasn't been imported yet. BANANAS!

Announcement Blog:

Documentation (Part of Incremental Refresh)


*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.


*******************
LET'S CONNECT!
*******************


***Gear***

#PowerBI #HybridTables #GuyInACube

[micahdail]

Even better idea:
A. Really cold data for more than 5 years ago in DQ mode.
B. 5 years archive imported.
C. 5 days of incremental refresh imported.
D. 1 day of real time in direct query.

This is the first thing I'm going to do with hybrid tables. THIS IS BANANAS!

[CepaCode]

This is indeed BANANAS! For those of us who have struggled with big data sets in import mode this really changes the game!

[andyparkerson]

This is really impressive. We are definitely going to check this out.

[Nazeerul_Hazard]

Great piece of engineering by powerbi team and great presentation from Patrick! 👍

[wadecbyt]

WHAAAATTTT!!! This is the definition of INSANEAMAZING. Nuff said.

[kovaisampath]

Awesome Patrick, thanks for this video.

[diphetu]

Hi Patrick... as usual i love your this Hybrid Table video and it is amazing the way you explain very

[aaron]

Dude love it!!! But PBI license navigation... need an app for that...lol... gonna share with the teams and admin... thanks!!

[rezatavakol]

That was super! Thanks a lot Patrick!
I was in need of such a this feature!

[saifali]

Great video! I Always benefit from your tutorials and Tips.
Hey Patrick I am looking for a solution to share Power Reports with people outside the Organisation. I am hoping you can make a video on that.

[jerypaz]

Patrick es fantástico muy buen video! el Direct query para la actualización más reciente es espectacular!

[guustvandijck]

Yoooo Patrick! Thanks as usual for an amazing video! There´s been some hints in previous videos/ documentation that it´s possible to do a sort of "reverse" hybrid table. So the latest data gets refreshed on import and older data is accessible through direct query. Any chance on a video on that? Or is there already documentation out there that I can read into?
Either way, happy new year and keep on rocking!

[snehil_gupta]

Hey Patrick! Thank you for all your amazing videos. Could you also please make a video about creating hybrid tables using dataflows. We currently import 6 years data using dataflows which refresh on a daily basis, however, we would want the performance to be better and retain only 2 years worth of data as import and the rest as direct query. Appreciate your help. Cheers!

[udayburidi]

Hey Patrick, Can we avoid direct query when we are using Imported data in the report ?

[DevereauBR]

!! Greatings from a Guy In the cub from BRAZIL !

[jaromgleed]

Hey Patrick. Love the videos and I just tried my first hybrid table on a slow dataset that was entirely direct query. I get an error though saying I can not create a hybrid table if the table has calculated columns. So are calculated column not allowed on hybrid tables or do I just need to make a change? I really prefer to use calculated column in my case rather than measures. Any insight would be a great help!

[qazq]

How does the measuring instruments work on the year-to-year basis at the interface between import and directquery? also Running-Count

What limitations will we meet in this regard?

[AHMEDALDAFAAE]

Hey Pat! Thank you so much for those amazing videos!!
BTW, you don't need to start with DQ. I saw other building their Hybrid table right away from the incremental refresh on an imported data. Please correct me or update your video!
Regards!!

[Jackof]

When a year has passed does it maintain the first year partition or does it drop it and now you have partitions 2018-2022?

[thomothomo]

Hi Patrick

This is impressive.

My question is can I use direct query when I use native query to load the table