Forum Discussion
Table Rows Limit
Based on my research, you need to specify dataReductionAlgorithm in capabilities.json. It describes how to reduce the amount of data exposed to the visual.
Hi RichardL,
I understand you're using TypeScript, but how is Power BI consuming it ? Via 'web' http ? In other words, what do you do when you select 'Get Data' ?
We have encoded data in JSON using python then into Power BI successfully Yes, we have had issues with maximum rows, but that has also been a server side limitation rather than Power BI. However, I have not see your error message before.
Cheers,
D
Hi djnww
I'm consumimg the data via 'web' http. The same row limit exists on both the web and in Power BI desktop. I see the limit of 1000 rows when I press F12 in Chrome or Edge to view console output.
Based on my research, you need to specify dataReductionAlgorithm in capabilities.json. It describes how to reduce the amount of data exposed to the visual.
Specifying dataReductionAlgorithm in capabilities.json did the trick. Thanks a bunch. I can now read in 30K rows. My dataViewMappings now looks like this:
"dataViewMappings": [
{
"table": {
"rows": {
"select": [
{ "for": { "in": "values" } }
],
"dataReductionAlgorithm": { "sample": { "count": 64000 } }
},
"rowCount": { "preferred": { "min": 2, "max": 100000 }, "supported": { "min": 1, "max": 100000 } }
}
}
],This is good progress. However, almost half of my table still gets truncated. Didn't the Power BI team say they were raising the 30K rows limit?
For a newbie.
How/where do you edit capabilities.json? where is capabilities located?
capabilities.json is located in the root folder of your project. Did you look?
