Forum Discussion

RichardL's avatar
RichardL
Microsoft Employee
9 years ago
Solved

Table Rows Limit

Hello, I'm creating a custom visual that reads data in from a table (csv file).  My table has three columns, and each column has 59,000 rows.  I am reading the rows in via TypeScript, but the latest ...
RichardL's avatar
RichardL
Microsoft Employee
9 years ago

v-chuncz-msft

 

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?