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 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?
Hello,
Thanks for your reply.
I did look. Im not sure where the root folder of the project is located or where is should look for that.
It is not in the folder where the power bi project file is stored.
Am I maybe misunderstanding something.
I am just importing data into Power BI using query ...
let
Source = Json.Document(Web.Contents("https://issues.companyname.com/rest/api/2/search?jql=project=PR&maxResults=3000")),
issues = Source[issues],So perhaps this is not a project.. Like I said in the previous message I am a newbie :)
Is there a way to include more search results for a just a query?
