# Vision: Power Table - Get dataset with 'configure cell' text-overridden data **URL:** \ **Category:** Ignition\ **Created:** [July 6, 2019, 10:28am UTC](https://forum.inductiveautomation.com/t/vision-power-table-get-dataset-with-configure-cell-text-overridden-data/26329 "2019-07-06T10:28:53Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Post date:** [July 6, 2019, 10:28am UTC](https://forum.inductiveautomation.com/t/vision-power-table-get-dataset-with-configure-cell-text-overridden-data/26329/1 "2019-07-06T10:28:53Z")
v7.9.10 I have a power table that I want to use for a trend viewer to drag tags onto an EasyChart, however my tags use device equip IDs e.g. FIT001 instead of a descriptive name. I store a description in the UDT instance via a passed UDT parameter. I’ve written a configureCells event handler to replace the default tag path with the device description + property name, but I now realise that this is a ‘render effect’ only if you will, and doesn’t modify the underlying dataset (makes sense). I’ve looked through the API but can’t find anything obvious that I can use to return a dataset that includes my modified values. Any help would be appreciated, cheers. Otherwise I can just repeat the same operations again, but obviously not ideal… ---
**Author:** ![mazeyrat](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mazeyrat/32/10955_2.png) [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\ **Post date:** [July 6, 2019, 10:48am UTC](https://forum.inductiveautomation.com/t/vision-power-table-get-dataset-with-configure-cell-text-overridden-data/26329/2 "2019-07-06T10:48:25Z")
the powerTable has a **viewDataset** property to read the data as displayed. [https://docs.inductiveautomation.com/display/DOC79/Power+Table](https://docs.inductiveautomation.com/display/DOC79/Power+Table) ---
**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Post date:** [July 6, 2019, 10:51am UTC](https://forum.inductiveautomation.com/t/vision-power-table-get-dataset-with-configure-cell-text-overridden-data/26329/3 "2019-07-06T10:51:27Z")
I did find that and try it, but it still displays the raw data. I think by ‘view’ it means the dataset only includes visible columns and probably only the non-filtered rows. ---
**Author:** ![mazeyrat](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mazeyrat/32/10955_2.png) [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\ **Post date:** [July 6, 2019, 11:01am UTC](https://forum.inductiveautomation.com/t/vision-power-table-get-dataset-with-configure-cell-text-overridden-data/26329/4 "2019-07-06T11:01:38Z")
you can perhaps populate the original dataset with the raw column and the descriptive one, and hide the column with the row data ? ---
**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Post date:** [July 6, 2019, 11:04am UTC](https://forum.inductiveautomation.com/t/vision-power-table-get-dataset-with-configure-cell-text-overridden-data/26329/5 "2019-07-06T11:04:46Z")
My dataset is coming from an SQL query and I need to run a tag read and some other logic on each row, so unfortunately I can’t manipulate the query to do that (unless I create an SQL table to store all of the device descriptions, but that wouldn’t be practical). I think I might be stuck replicating the transform logic 😕 It’s already in a function that I can call, so it’s not a big deal, but it is less efficient than I was hoping ---
**Author:** ![mazeyrat](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mazeyrat/32/10955_2.png) [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\ **Post date:** [July 6, 2019, 11:16am UTC](https://forum.inductiveautomation.com/t/vision-power-table-get-dataset-with-configure-cell-text-overridden-data/26329/6 "2019-07-06T11:16:10Z")
Ok I see. Not sure that the viewDataset not being affected by the configureCells is the intentional behavior… It’s perhaps a bug ? ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [July 6, 2019, 2:02pm UTC](https://forum.inductiveautomation.com/t/vision-power-table-get-dataset-with-configure-cell-text-overridden-data/26329/7 "2019-07-06T14:02:03Z")
Place the query on a custom property instead of the table’s `data` property. Then use scripting (or possibly my view() function from Simulation Aids) to generate the adjusted dataset for `data` whenever the query delivers its result. ---
**Author:** ![lachguerabdallah](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lachguerabdallah/32/25558_2.png) [@lachguerabdallah](https://forum.inductiveautomation.com/u/lachguerabdallah)\ **Post date:** [November 17, 2020, 10:27am UTC](https://forum.inductiveautomation.com/t/vision-power-table-get-dataset-with-configure-cell-text-overridden-data/26329/9 "2020-11-17T10:27:17Z")
did you solve it? I have the same problem.