Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I develop with custom visuals.
I have one question.
How is it sampled when more than 30,000 data is imported?
* In dataReductionAlgorithm of capabilities.json setting
sample is being set.
"categorical": {
"categories": {
"select": [{
"bind": {
"to": "xxxxxxxxx"
}
}],
"dataReductionAlgorithm": {
"sample": {
"count": 30000
}
}
},
* In the documentation
sample: Reduce the dataset by a simple sampling algorithm, limited to a count number of items.It means that the first and last items are included, and a count number of items have equal intervals between them.For example, if you have a dataset [0, 1, 2, ... 100] and a count of 9, you'll receive the values [0, 10, 20 ... 100].
But I feels different.
*Shouldn't Power BI read more than 30,000 data?
that's all. Thank you
Solved! Go to Solution.
Hi @Anonymous,
I have requested help from the Custom Visuals team in the past on how the sampling reduction method actually works, as I use it in one of my visuals. All I could get confirmed is that it is not the same as the one used in the core visuals. You might have better luck if you want to liaise with them at pbicvsupport@microsoft.com.
You can go beyond the 30,000 row limit in TypeScript custom visuals, but it is still limited by the amount of memory the development visual sandbox is consuming. I can consistently get 150,000 rows in a test visual I have set up.
If you want to explore this, you need to work with fetchMoreData. Note that you will need to change your dataReductionAlgorithm to window.
I have a couple of repositories that demonstrate this that you are welcome to refer to:
Hopefully some of this might be useful for you. Good luck!
Daniel
If my post solves your challenge, then please consider accepting as a solution to help other forum members find the answer more quickly 🙂
Proud to be a Super User!
My course: Introduction to Developing Power BI Visuals
On how to ask a technical question, if you really want an answer (courtesy of SQLBI)
Hi @Anonymous,
I have requested help from the Custom Visuals team in the past on how the sampling reduction method actually works, as I use it in one of my visuals. All I could get confirmed is that it is not the same as the one used in the core visuals. You might have better luck if you want to liaise with them at pbicvsupport@microsoft.com.
You can go beyond the 30,000 row limit in TypeScript custom visuals, but it is still limited by the amount of memory the development visual sandbox is consuming. I can consistently get 150,000 rows in a test visual I have set up.
If you want to explore this, you need to work with fetchMoreData. Note that you will need to change your dataReductionAlgorithm to window.
I have a couple of repositories that demonstrate this that you are welcome to refer to:
Hopefully some of this might be useful for you. Good luck!
Daniel
If my post solves your challenge, then please consider accepting as a solution to help other forum members find the answer more quickly 🙂
Proud to be a Super User!
My course: Introduction to Developing Power BI Visuals
On how to ask a technical question, if you really want an answer (courtesy of SQLBI)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
16 | |
2 | |
2 | |
1 | |
1 |