Use 3rd party Grid/pivot control that allows cell edit in visual

[karaoan]

Hi,

We are in the process of developing a solution that enables users to enter data from a grid in a PBI visual. We have experimented with a few but couldn't find one that exactly fits our needs. We got a few to work quite well in the PBI Desktop but they then don't work on the web service apparently because of control size restrictions (PBI service prevents control to run above 1MB visual size). Any tips with controls that work?

PS: it would help if Microsoft could update visual/API documentation that the size restriction of controls is in place for visuals. Would have saved days of work...

[v-chuncz-msft]

@karaoan,

You might need to think about updating the dataset, not doing it in the presentation layer.

[karaoan · Accepted solution]

@v-chuncz-msft Sam, The volume of the data source had nothing to do with it. After a lot of testing it was confirmed (by now also from MS) that you can't use controls in visuals that exceed 2MB. We have adapated our code accordingly and now it works.

Martin

www.powerbiexperts.com.au