Thank you for a great course on Deneb. I just completed it and look forward to implementing it in my reports.
can you share some of your suggestions on the following:
If a native visual just about does the job, is there a scenario where you would still use deneb? and why
I have very limited understanding at the moment regarding this,:
I know there is a default cap of 10,000 rows on dataset. and i know that i can remove the limit by changing the override row Limits setting.
Also as per the documentation here : https://deneb-viz.github.io/dataset. there must be some considerations made when removing this cap.
My question is that in a scenario, where, lets say my dataset has a million rows of sales data for year 2022, or a scenario where my dataset is small to start with but will grow very soon,
should i prefer to bring measures in deneb ? or okay to bring in the columns and still go with visual level calculations , and remove the 10,000 rows cap on dataset at the time of publishing ?
Thanks for your kind words; I’m glad you found the course interesting.
I’d use native visuals every time if performance is/may be an issue.
I’ll admit I haven’t ever run into performance issues with a Deneb visual, but I’d always try to aggregate the data and as much as possible in Power BI before providing the dataset to Deneb. I’d, as well, always use explicit measures instead of naked columns unless there is a compelling reason why not to.
That input helps. and just as a follow up question. - Again I think i dont quite understand this as much.
Please correct me if i am wrong with following, :
if i am using an explicit measure that is aggregating the values, i dont think i would ever cross 10,000 rows within visual ( i guess thats unless i have over 10,000 categories against which i want to see the numbers)
I should worry about the row limit if only i have to bring the columns directly to deneb. correct?
so in short my question is When exactly should I consider removing the 10,000 row limit ?
Hi @jsodhi. I’ve been using Deneb for about 16 months now and have not removed the 10K row limit once, so in my experience I’d say remove it rarely if ever. That being said, I’d check the data pane while editing your Deneb visual and if you have over 10K rows of data, then try removing the limit. Ultimately, as you say, the situation as I see it is that you are unlikely to ever be close to this limit if you’re using explicit measures.
Greg
