# Discourse Data Explorer Power BI integration

**URL:** https://meta.discourse.org/t/discourse-data-explorer-power-bi-integration/159577
**Category:** Administrators
**Tags:** tutorial, platforms
**Created:** [August 2, 2020, 12:44pm UTC](https://meta.discourse.org/t/discourse-data-explorer-power-bi-integration/159577 "2020-08-02T12:44:18Z")
**Posts on this page:** 5
**Page:** 2

<div class="post-metadata">

### Author: ![dinoscool3](https://avatars.discourse-cdn.com/v4/letter/d/4491bb/32.png) [@dinoscool3](https://meta.discourse.org/u/dinoscool3)
#### Post date: [February 2, 2022, 3:42pm UTC](https://meta.discourse.org/t/discourse-data-explorer-power-bi-integration/159577/21 "2022-02-02T15:42:34Z")

</div>

Has anyone been able to get the data credentials to verify on Power BI web to allow for automatic updates? Anytime I do it in Settings it just gets a 404 error…

---

<div class="post-metadata">

### Author: ![jordan-violet](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jordan-violet/32/281428_2.png) [@jordan-violet](https://meta.discourse.org/u/jordan-violet)
#### Post date: [February 19, 2025, 7:13pm UTC](https://meta.discourse.org/t/discourse-data-explorer-power-bi-integration/159577/22 "2025-02-19T19:13:56Z")

</div>

@loginerror does this do a complete 1:1 copy of _all_ data in Discourse, including any new tables/fields/values that may have been added by plugins, etc.?

I saw your post [here](https://meta.discourse.org/t/discourse-data-explorer-power-bi-integration/159577/11), but wasn’t sure if _all_ really meant _all_.

---

<div class="post-metadata">

### Author: ![loginerror](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/loginerror/32/156605_2.png) [@loginerror](https://meta.discourse.org/u/loginerror)
#### Post date: [February 20, 2025, 4:40pm UTC](https://meta.discourse.org/t/discourse-data-explorer-power-bi-integration/159577/23 "2025-02-20T16:40:10Z")

</div>

> [@jordan-violet](#):
>
> does this do a complete 1:1 copy of _all_ data in Discourse, including any new tables/fields/values that may have been added by plugins, etc.?

It works by loading up one entire table per query. It would take multiple queries to get everything.

The post above that you linked is simply about potentially being able to pull some tables in one go without pagination in certain scenarios.

---

<div class="post-metadata">

### Author: ![merefield](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/merefield/32/176214_2.png) [@merefield](https://meta.discourse.org/u/merefield)
#### Post date: [February 20, 2025, 11:22pm UTC](https://meta.discourse.org/t/discourse-data-explorer-power-bi-integration/159577/24 "2025-02-20T23:22:28Z")

</div>

Wouldn’t it be straightforward to interface directly with the psql database?

Using a querying tool to query a querying tool seems like a good interim workaround but not the final solution?

---

<div class="post-metadata">

### Author: ![jordan-violet](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jordan-violet/32/281428_2.png) [@jordan-violet](https://meta.discourse.org/u/jordan-violet)
#### Post date: [February 24, 2025, 7:58pm UTC](https://meta.discourse.org/t/discourse-data-explorer-power-bi-integration/159577/25 "2025-02-24T19:58:33Z")

</div>

I don’t believe we have the option to connect directly to the underlying postgres database in an enterprise setup that’s hosted by CDCK.

[Previous page](https://meta.discourse.org/t/discourse-data-explorer-power-bi-integration/159577.md?page=1)