Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
acanepa
Resolver I
Resolver I

PowerApps Limitation on Rows

Hello,

 

I'm using PowerApps to extract data from PowerBI. The problem is that there is a limit on the number of rows to 1,000.

 

I've edited the custom visual - attached - to allow 30,000 rows to display, but I'm still getting the error that I have too many values to display.

 

TooManyValues.png

 

Code added to the JSON file.

 

"dataViewMappings": [
{
"table": {
"rows": {
"dataReductionAlgorithm": {
"top": {
"count": 30000
}
},
"for": {
"in": "table"
}
}
},
"conditions": [
{
"table": {
"min": 0
}
}
]
}
]

I uploaded the custom visual to the following link:

https://ufile.io/qbkbv

 

Regards,

2 REPLIES 2
v-chuncz-msft
Community Support
Community Support

@acanepa,

 

You may refer to this thread and change all the code related to guid accordingly.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hello @v-chuncz-msft,

 

Thanks for your response. I've tried two approaches, one regenerating the visual to pbviz and the second only changing the guid through 7zip to edit without "extracting" the file.

 

1rst approach

I'm rebuilding the visual into a new one. I've the following error

 

pbviz package.pngff

 

The packages installed in NODE are:

  • promise-js
  • callback-promise
  • require-promise
  • node-promise
  • promise
  • es6-promise-polyfill
  • es6-promise
  • ts-events

Also, the API is updated to 1.1.0 

 

The GitHub page is broken.

 

2nd approach

 

I've tried to edit the file only editing the pbviz.json and resource.json changing the GUID field.

 

Changes made in :

(on the visual JSON object)

 

  • package.json
  • PowerApps_PBI_CV_C29F1DCC_81F5_4973_94AD_0517D44CC06A.pbiviz.json

from

PowerApps_PBI_CV_C29F1DCC_81F5_4973_94AD_0517D44CC06A

 

to

PowerApps_PBI_CV_A3BC6498_F417_4A2C_8F5C_316851D68FE7

* for the object called resources inside package.json I'm not touching the element called file, that makes a reference into the file inside the resources folder.

 

The first approach gives an error on the building. The second approach retrieves a blank custom visual.

 

Thanks for the responses.

 

Regards,

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.