# Pass SQL query to power chart

**URL:** <https://forum.inductiveautomation.com/t/pass-sql-query-to-power-chart/51177>\
**Category:** Ignition Early Access\
**Created:** [September 21, 2021, 3:44am UTC](https://forum.inductiveautomation.com/t/pass-sql-query-to-power-chart/51177 "2021-09-21T03:44:16Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![nader.chinichian](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nader.chinichian/32/9261_2.png) [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\
**Post date:** [September 21, 2021, 3:44am UTC](https://forum.inductiveautomation.com/t/pass-sql-query-to-power-chart/51177/1 "2021-09-21T03:44:16Z")

</div>

Hello  
I have a client that has a lot of tag history in OSI PI platform. I can easily show the trend of those tag in time series chart by using namedquery but if I want to enjoy using of power chart for them, it seems that power chart can only accept ignition historian.  
so I wonder is there any trick that I can use some script to make dataset ready for power chart and pass them to it?

---

<div class="post-metadata">

**Author:** ![schenk](https://avatars.discourse-cdn.com/v4/letter/s/6bbea6/32.png) [@schenk](https://forum.inductiveautomation.com/u/schenk)\
**Post date:** [September 21, 2021, 4:27am UTC](https://forum.inductiveautomation.com/t/pass-sql-query-to-power-chart/51177/2 "2021-09-21T04:27:34Z")

</div>

I haven’t used it myself yet, but have you looked into using the [DB Table Historian Provider](https://docs.inductiveautomation.com/display/DOC81/DB+Table+Historian+Provider)?