# PowerChart with data from different storage providers

**URL:** <https://forum.inductiveautomation.com/t/powerchart-with-data-from-different-storage-providers/93589>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [July 23, 2024, 8:18am UTC](https://forum.inductiveautomation.com/t/powerchart-with-data-from-different-storage-providers/93589 "2024-07-23T08:18:33Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Adam\_Rab](https://avatars.discourse-cdn.com/v4/letter/a/53a042/32.png) [@Adam\_Rab](https://forum.inductiveautomation.com/u/Adam_Rab)\
**Post date:** [July 23, 2024, 8:18am UTC](https://forum.inductiveautomation.com/t/powerchart-with-data-from-different-storage-providers/93589/1 "2024-07-23T08:18:33Z")

</div>

I'm working with Gateway 8.1.20 (b2022082313) on Perspective.

I want to use PowerChart with data form different storage providers. When I use data from one storage providers, everything works correctly.

When I use data from two storage providers and chose historical (not real-time) data I have errors like below. What can I do to show data from different storage providers with historical mode?

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/3/f3dd9155d2709e4c43217954491667a3975d7e18.png)

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/5/d5b020dcb99059999ecdeb8e310317423ef3c3d1.png)

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/5/75140d855b81b17fa8c5b1fa5c1450b8c31a74ab.png)

---

<div class="post-metadata">

**Author:** ![Adam\_Rab](https://avatars.discourse-cdn.com/v4/letter/a/53a042/32.png) [@Adam\_Rab](https://forum.inductiveautomation.com/u/Adam_Rab)\
**Post date:** [July 29, 2024, 7:21am UTC](https://forum.inductiveautomation.com/t/powerchart-with-data-from-different-storage-providers/93589/2 "2024-07-29T07:21:13Z")

</div>

The data are from different database: Microsoft SQLServer and SQLite. Is it reason of this issue?

---

<div class="post-metadata">

**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 29, 2024, 11:31am UTC](https://forum.inductiveautomation.com/t/powerchart-with-data-from-different-storage-providers/93589/3 "2024-07-29T11:31:31Z")

</div>

There are so many different issues with using SQLite for history that the right answer is "don't". If you need something free, use PostgreSQL or MariaDB.

---

<div class="post-metadata">

**Author:** ![Adam\_Rab](https://avatars.discourse-cdn.com/v4/letter/a/53a042/32.png) [@Adam\_Rab](https://forum.inductiveautomation.com/u/Adam_Rab)\
**Post date:** [July 30, 2024, 6:15am UTC](https://forum.inductiveautomation.com/t/powerchart-with-data-from-different-storage-providers/93589/4 "2024-07-30T06:15:09Z")

</div>

great thank you for help. Now I know what I need to do!