I can’t seem to get more than 100 columns in a dashboard. (I know, wth, but our people like it in classic and would like it in kinetic.) Is anyone aware of a limitation? I used tried this setting (thanks @hmwillett ) to no avail.
Thanks,
Nancy
3 Likes
4 Likes
@tpogue has run into this also
They wanna dump all the data when they wanna dump it all. And they do not have access to the BAQs so… It is incredibly interesting 
data noting every specifying bit of technical information on our pumps.
2 Likes
You can make an excel workbook that retrieves the data via odata. Then they can just refresh.
3 Likes
those darn outdated desktop progrmas will never be able to match modern web apps!
3 Likes
It’s a similar situation here where I work. Some of their “dashboards” seem to try to pull every table in Epicor together. I was a bit amazed at it when I first came here. Like, deer in the headlights amazed!
2 Likes
I seem to remember that the columns are there but you can display only 100. If you go to Personalize Columns I think you will see them all.
2 Likes
That’s bs. I need a dashboard with around 150.
1 Like
You could split the columns into two grids. Create two identical grids with all the columns and let them choose which ones to display in each one. They would have to export both to Excel and merge. Or set a nightly task to run the BAQ and save to a file they can access. We do this for time-sensitive data, i.e. month end. But I think @aosemwengie1’s solution is the best. Then they can refresh the data whenever they want.