# MS Power BI with Ignition Historina data

**URL:** <https://forum.inductiveautomation.com/t/ms-power-bi-with-ignition-historina-data/17656>\
**Category:** Ignition\
**Created:** [April 10, 2018, 11:49am UTC](https://forum.inductiveautomation.com/t/ms-power-bi-with-ignition-historina-data/17656 "2018-04-10T11:49:42Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![tamerplc](https://avatars.discourse-cdn.com/v4/letter/t/d78d45/32.png) [@tamerplc](https://forum.inductiveautomation.com/u/tamerplc)\
**Post date:** [April 10, 2018, 11:49am UTC](https://forum.inductiveautomation.com/t/ms-power-bi-with-ignition-historina-data/17656/1 "2018-04-10T11:49:42Z")

</div>

I am trying to get access to Ignition Historian data to create some dashboard on PowerBi Tools . the problem which i faced i found historised data but without tag name or tag path on Tag id .  
is there any way except transaction group to get data from table direct

---

<div class="post-metadata">

**Author:** ![mcarritt1](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mcarritt1/32/4262_2.png) [@mcarritt1](https://forum.inductiveautomation.com/u/mcarritt1)\
**Post date:** [April 10, 2018, 12:51pm UTC](https://forum.inductiveautomation.com/t/ms-power-bi-with-ignition-historina-data/17656/2 "2018-04-10T12:51:33Z")

</div>

You will also need to tie in the sqlth\_te table to your report data, which is the directory of tagnames with ID’s.

---

<div class="post-metadata">

**Author:** ![mrogers](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mrogers/32/4110_2.png) [@mrogers](https://forum.inductiveautomation.com/u/mrogers)\
**Post date:** [April 10, 2018, 4:09pm UTC](https://forum.inductiveautomation.com/t/ms-power-bi-with-ignition-historina-data/17656/3 "2018-04-10T16:09:39Z")

</div>

Take a look at [this](https://docs.inductiveautomation.com/display/SE/Tag+History+Tables+Reference) - more details on the historian tables.

---

<div class="post-metadata">

**Author:** ![tamerplc](https://avatars.discourse-cdn.com/v4/letter/t/d78d45/32.png) [@tamerplc](https://forum.inductiveautomation.com/u/tamerplc)\
**Post date:** [April 10, 2018, 5:48pm UTC](https://forum.inductiveautomation.com/t/ms-power-bi-with-ignition-historina-data/17656/4 "2018-04-10T17:48:20Z")

</div>

Thanks a lot .documents cover most of I need.