Add Partitions to a SSAS Tabular Model

Get my Modern Data Essentials training (for free) & start building more reliable data architectures

-----

Learn how to add partitions to a tabular cube in SSAS.

Title & Tags:
Add Partitions to a Tabular Model | SQL Server Analysis Services (SSAS) Tutorial
#kahandatasolutions #sqlserveranalysisservices#dataengineering

[KahanDataSolutions]

Get my Modern Data Essentials training (for free) & start building more reliable data architectures

[adamlincoln]

Thanks man, look so easy after watch your video.

[SalehShayeb-ss]

@KahanDataSolutions
I believe that the part of the partition will serve the model efficiency and only the needed partition will be triggered to refresh, but the issue, in my opinion, is that if I need multiple partitions to be executed, the main (source) view will be triggered multiple times, and I simulated that from the SQL profiler, this will lead to making a real bottleneck issue on the server, so what do you think about solving such issue?

[maheshc]

If I've set my partition till May'23. As now we are in June'23, my cube should create June'23 partition dynamically. Can you please help.

[Kunal]

Hi, its a nice video I have a question how to go for a dynamic partitions in like rolling dates irrespective of calendar months, kindly share any such video. thank you

[adamlincoln]

At to click in DESIGN power query don't open, how can i make work ?

[heshamh]

at the year 3000 who the hell was that developer ! LOL xD, .... just kidding great job Bro