@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?
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
In the PowerQuery editor, there are options on a date column that allow you to filter dynamically. For example, you can select "In the last" from the drop down and input how many days, months, years, etc. you want it to look back from the current day. This will result in a query that has a Filtered Rows query that looks something like this -- #"Filtered Rows" = Table.SelectRows(dbo_vw_CalendarDate, each Date.IsInPreviousNMonths([CalendarDate], 3)) . If you are using T-SQL, you could use a DATEDIFF function in your WHERE clause and have it compared to the current date . For example, SELECT * WHERE [DateColumn] > DATEDIFF(MONTH, -3, GETDATE()) Hope this helps!
Hi, I am able to set my first partition for last 3 days on data column but while processing I am getting error for duplicate records, the reason is overlapping range do we need to set the original partition to the another data range - whats your view?
Try updating the original partition as well in a way so that it does not overlap. For example, the first partition has a dynamic [end date] of three days prior to today, and then the new partition has a dynamic [start date] greater than or equal to 3 days from today.
Want to build a reliable, modern data architecture without the mess?
Here’s a free checklist to help you → bit.ly/kds-checklist
Thanks man, look so easy after watch your video.
@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?
Thanks 😊
you are welcome!
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
In the PowerQuery editor, there are options on a date column that allow you to filter dynamically. For example, you can select "In the last" from the drop down and input how many days, months, years, etc. you want it to look back from the current day.
This will result in a query that has a Filtered Rows query that looks something like this -- #"Filtered Rows" = Table.SelectRows(dbo_vw_CalendarDate, each Date.IsInPreviousNMonths([CalendarDate], 3)) .
If you are using T-SQL, you could use a DATEDIFF function in your WHERE clause and have it compared to the current date . For example, SELECT * WHERE [DateColumn] > DATEDIFF(MONTH, -3, GETDATE())
Hope this helps!
Hi, I am able to set my first partition for last 3 days on data column but while processing I am getting error for duplicate records, the reason is overlapping range do we need to set the original partition to the another data range - whats your view?
Try updating the original partition as well in a way so that it does not overlap. For example, the first partition has a dynamic [end date] of three days prior to today, and then the new partition has a dynamic [start date] greater than or equal to 3 days from today.
@@ksh-v8x i have the same question. Did you resolve this problem? Please share. Thanks
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.
At to click in DESIGN power query don't open, how can i make work ?
Can you explain more of what you are seeing on your screen?
at the year 3000 who the hell was that developer ! LOL xD , .... just kidding great job Bro
Lol thank you!