Could you show which techniques you used to create the Sales Amount Slow measure? To benchmark I often find myself trying to deliberately slow down measures but sadly there's no sleep function yet in DAX.
Great video! I would also be interested to see what exactly made the "Sales Amount Slow Measure" perform poorly and what the best practice is to improve it.
I developed a BI Model in my PPU Workspace. When Incremental refresh for my dataset: - 1st-Full Load: wait 3h. And then I Checked my Model Size = 35 Gib Ram. - 2nd-Incremental refresh: I got error:Memory error: you have reach the maximum allowable memory allocation for your tier. I think the PPU limit is 100 Gib Ram?
When you're doing a full refresh (even if it's incremental) the data refresh limit is half the dataset limit. So if your dataset limit is 100 Gib the maximum size your dataset can be when you do a refresh (give or take a few Gib) is 50 Gib. This is because the PBI service takes a copy of the dataset in memory so it's the total of the dataset plus the copy that cannot exceed 100 Gib.
@@trantrongnghiaw if you have access to the Capacity Metrics report it will give you an accurate size. Also I've just seen in this video that DAX Studio 3 will also help. It will be interesting to know if the two values tally - I haven't tried yet.
Its still very confusing. When I check my tabular model size from SSMS it shows different sizes when checked from DAX studio . Which one must we trust ? Ssms or Dax studio ?
Could you show which techniques you used to create the Sales Amount Slow measure? To benchmark I often find myself trying to deliberately slow down measures but sadly there's no sleep function yet in DAX.
Great video! I would also be interested to see what exactly made the "Sales Amount Slow Measure" perform poorly and what the best practice is to improve it.
Love the content, always a bless to see Marco...
Cheers guys!
nicely explained...thank you.
Thank you Patrick and Marco for the video....could you suggest what the final size of my dataset to be considered.
Great video! I learned a couple things in this one. Thx
Thumbnails and intro are on the spot. Effective click bait, loved the video
Hi @ Patric and Marco.I still want to understand will the refresh fail if the size shown in dax studio will exceed 1 gb for pro licence
Lovely explained. Thank you guys
Fantastic! Memory is freed up after a certain time? what is the amount of time
I developed a BI Model in my PPU Workspace.
When Incremental refresh for my dataset:
- 1st-Full Load: wait 3h. And then I Checked my Model Size = 35 Gib Ram.
- 2nd-Incremental refresh: I got error:Memory error: you have reach the maximum allowable memory allocation for your tier.
I think the PPU limit is 100 Gib Ram?
When you're doing a full refresh (even if it's incremental) the data refresh limit is half the dataset limit. So if your dataset limit is 100 Gib the maximum size your dataset can be when you do a refresh (give or take a few Gib) is 50 Gib. This is because the PBI service takes a copy of the dataset in memory so it's the total of the dataset plus the copy that cannot exceed 100 Gib.
@@tyoob But at 2nd: Incremental load just 2 days. It's very few rows. So 35 Gib + few rows = I don't think It costs over 65 Gib (100-35).
@@trantrongnghiaw if you have access to the Capacity Metrics report it will give you an accurate size. Also I've just seen in this video that DAX Studio 3 will also help. It will be interesting to know if the two values tally - I haven't tried yet.
Its still very confusing. When I check my tabular model size from SSMS it shows different sizes when checked from DAX studio . Which one must we trust ? Ssms or Dax studio ?
the question is akward but deserved to be asked. thanks! it is helping optimize my report
Echoing on below comments, would be great to see what slowed down the report that much :)
As a colleague said....its not the size of your data that matters...its hiw you use it
I am curious about whether you are the hidden people who was the introducer of sep 2022 PBI New feature
"I'm trying to get a grip....". Dying
That's what she said.
Bruh, where's your dual role RLS (full outer) solution?
Inappropriate caption pattrick
As always... The size you see is smaller... The REAL size is hidden in the memory. 🙂
Marco is so cute