Setup a Reverse Hybrid Table without using Tabular Editor for Power BI!

Hybrid Tables can be very useful for mixing archived data with current data. Pat Mahoney joins Patrick to show how to configure a Hybrid Table within a Power BI dataset without using Tabular Editor. Just some straight "M"agic.
Hybrid Table Documentation:
learn.microsof...
Connect with Pat Mahoney:
/ mahoneypa
/ patrick-mahoney-3138526
/ @hoosierbi5669
hoosierbi.com/
📢 Become a member: guyinacu.be/me...
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
🎓 Guy in a Cube courses: guyinacu.be/co...
*******************
LET'S CONNECT!
*******************
-- / guyinacube
-- / awsaxton
-- / patrickdba
-- / guyinacube
-- / guyinacube
-- guyinacube.com
**Gear**
🛠 Check out my Tools page - guyinacube.com...
#PowerBI #HybridTable #GuyInACube

[@christophehervouet3280]

Great post Pat and Patrick , congrats
Yes most of my clients only whant to use power bi or visual studio as external tool only for extra modeling (100% MS products)

[@beyondtruthandlies]

This is absolute bananas. Fooling the system. Thanks Pat!❤

[@mhjii]

Wow! What an amazing way to get the best of all worlds!

[@toma4528]

This in fact is Bananas

[@ItsNotAboutTheCell]

Awesome video! It's all "M"agic!

[@MSFT_ScottSewell]

Wow!
Amazing work Pat!

[@jainbhavesh9]

That's an amazing trick. Thanks

[@rapatel1642]

Great work

[@felipesouza4251]

Amazing! Can you share the Pbix File to Study? I'm struggling to make the reverse Hybrid Table using Aggregate Tables.

[@VishnuPriya-ng6wk]

Is it possible for incrementally refresh table which has future dates like future forecast? Incremental refresh settings allows to set the time frame in the past only

[@project365]

Rather than using RangeStart and RangeEnd to filter in PQ, I would suggest you use a conditional logic in PQ to check if the RangeEnd is today's date, then add say X months / years to RangeEnd. I haven't tried this out, but just my thought

[@VishnuPriya-ng6wk]

@@project365 , how would it help to incrementally refresh just few days?

[@project365]

Yes it will. You need to know how many days in future you want to the part of the refresh, and add X number of days in the above logic to RangeEnd. Remember, IR refresh doesn't support this feature in settings, you need to hack it in PQ

[@project365]

Benefit of hybrid tables, by its nature, is have archived data imported and recent data direct queried. Why would I want to reverse this?

[@jontew8853]

It lets you have high imported performance on recent data without needing to import old history that isn’t queried often. Just like dynamic tiering.

[@TanjilulA]

This approach can lower the size of your dataset and also reduce refresh times.

[@wHaTsThIsThInGdO]

How will hybrid technology make GMOs?