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!
1 Like
IAmGav
(Gavin Perch)
August 6, 2020, 10:21am
2
The following article should give you some guidelines as Power BI & Tableau is almost the same
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…
1 Like
Thanks! Is there a way to simply configure it manually so I can connect the PostgreSQL database that Data Explorer is running upon directly?
IAmGav
(Gavin Perch)
August 6, 2020, 10:47am
4
the PostgreSQL DB is inside the discourse container.
I found this article. I hope this helps
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:
Can you provide me @IAmGav with further guidance on that?
IAmGav
(Gavin Perch)
August 6, 2020, 12:17pm
9
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
Address would be Discord IP?
neounix
(Dark Matter)
August 6, 2020, 1:00pm
11
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:
See also:
https://github.com/tfoldi/tableau-server-docker
Note: This docker image might help things along (not tested or checked out):
https://hub.docker.com/r/pvtmert/tableau
2 Likes