Hey there Community! Pretty much as in the title. We want to get some data from our Data Explorer queries to Tableau report. Is there any guide / community thread that will guide us how to connect Tableau to our Discourse Data Source (which is PostgreSQL I guess). Thanks a lot for the help!

The following article should give you some guidelines as Power BI & Tableau is almost the same :slight_smile: [תמונה] Discourse Data Explorer Power BI integration Administrators Discourse Data Explorer Power BI integration I recently made a cool Power BI function which fetches Data Explorer data directly to Power BI with minimal overhead. Thus, if you are like me, and you wanted to have the data being automatically pulled and refreshed via the Power BI app, here’s the code of the function you should put in the Advanced Editor in Power BI: (queryID) => let resultCount = 1000, otherNameForPage = 0, GetPage = (otherNameForPage) => let…

Thanks! Is there a way to simply configure it manually so I can connect the PostgreSQL database that Data Explorer is running upon directly?

the PostgreSQL DB is inside the discourse container. I found this article. I hope this helps [Sojo] Connecting to Postgresql in a docker container from outside postgresql, docker asked by Sojo on 06:39AM - 08 Jun 16 UTC

We’ll try that and eventually circle back to you!

The problem is that there is no way to connect to PostgreSQL through docker when it comes to data sources in Tableau

I need to provide following details: [Screenshot 2020-08-06 at 13.56.06]

Can you provide me @IAmGav with further guidance on that?

Address would be discord IP Username: root Password: would be root password Db name: note sure would need to go check it Disclaimer: I have not done this myself yet

Dear @Konrad_Sopala The easiest way to accomplish what you want is to run Tableau in a Docker container. That way, you can take advantage of the core Docker networking capablities between containers. However, if you run Tableau outside Docker, you are going to have “a bear of a time” trying to get this to work smoothly. Hope this helps. Reference: https://databoss.starschema.net/tableau-server-linux-docker-container/ See also: https://github.com/tfoldi/tableau-server-docker Note: This docker image might help things along (not tested or checked out): pvtmert/tableau - Docker Image

Data Explorer + Tableau

קהילה נתונים ודיווח

Konrad_Sopala (KonradSopala) 6 באוגוסט,‏ 2020,‏ 12:50pm 10

Address would be Discord IP?

נושא		תגובות	צפיות
How can I use GUI to access the postgresql db in docker Self-hosting	1	767	4 באוגוסט,‏ 2023
Database connection to QuickSight Product Support	2	618	29 באוקטובר,‏ 2021
How to export data for analysis? Product Support	1	2760	28 באפריל,‏ 2016
How to access the discourse database? Self-hosting	13	17623	10 במרץ,‏ 2022
How to access Discourse forum Database to use for PowerBI reporting? Data & reporting sql-query	1	384	10 באפריל,‏ 2024

Data Explorer + Tableau

נושאים קשורים