Hello,
I'm posting this message to find out if an integration between WAPT and Power BI is currently possible.
I'd like to create dashboards using data from WAPT.
Thanks in advance.
Fred
Integration of WAPT reports into Power BI
Forum Rules
Community Forum Rules
* English support on www.reddit.com/r/wapt
* French community support is available on this forum
* Please prefix the topic title with [RESOLVED] if it is resolved.
* Please do not edit a topic that is tagged [RESOLVED]. Open a new topic referencing the old one.
* Specify the installed WAPT version, full version, and build number (2.2.1.11957 / 2.2.2.12337 / etc.) as well as the Enterprise/Discovery edition.
* Versions 1.8.2 and earlier are no longer supported. The only questions accepted regarding version 1.8.2 are related to upgrading to a supported version (2.1, 2.2, etc.).
* Specify the server OS (Linux/Windows) and version (Debian Buster/Bullseye - CentOS 7 - Windows Server 2012/2016/2019).
* Specify the OS of the administration/package creation machine and the machine with the problematic agent, if applicable (Windows 7/10/11/Debian 11/etc.).
* Avoid asking multiple questions when opening a topic, otherwise it may be ignored. If there are multiple topics, open separate topics, preferably one after the other and not all at the same time (i.e., do not spam the forum).
* Include code snippets, screenshots, and other images directly in the post. Links to Pastebin, Bitly, and other third-party sites will be systematically removed.
* As with any community forum, support is provided voluntarily by members. If you require commercial support, you can contact Tranquil IT's sales department at 02.40.97.57.55
Community Forum Rules
* English support on www.reddit.com/r/wapt
* French community support is available on this forum
* Please prefix the topic title with [RESOLVED] if it is resolved.
* Please do not edit a topic that is tagged [RESOLVED]. Open a new topic referencing the old one.
* Specify the installed WAPT version, full version, and build number (2.2.1.11957 / 2.2.2.12337 / etc.) as well as the Enterprise/Discovery edition.
* Versions 1.8.2 and earlier are no longer supported. The only questions accepted regarding version 1.8.2 are related to upgrading to a supported version (2.1, 2.2, etc.).
* Specify the server OS (Linux/Windows) and version (Debian Buster/Bullseye - CentOS 7 - Windows Server 2012/2016/2019).
* Specify the OS of the administration/package creation machine and the machine with the problematic agent, if applicable (Windows 7/10/11/Debian 11/etc.).
* Avoid asking multiple questions when opening a topic, otherwise it may be ignored. If there are multiple topics, open separate topics, preferably one after the other and not all at the same time (i.e., do not spam the forum).
* Include code snippets, screenshots, and other images directly in the post. Links to Pastebin, Bitly, and other third-party sites will be systematically removed.
* As with any community forum, support is provided voluntarily by members. If you require commercial support, you can contact Tranquil IT's sales department at 02.40.97.57.55
Hello,
I apologize for not having checked this thread recently.
Thank you for your reply.
Perhaps you could clarify the default database name used by WAPT?
This would allow me to test a new connection string in Power BI.
I've looked at the configuration in the WAPT console as well as the provided configuration file, but I haven't found any relevant information.
Thank you in advance.
Fred
I apologize for not having checked this thread recently.
Thank you for your reply.
Perhaps you could clarify the default database name used by WAPT?
This would allow me to test a new connection string in Power BI.
I've looked at the configuration in the WAPT console as well as the provided configuration file, but I haven't found any relevant information.
Thank you in advance.
Fred
-
sfonteneau
- WAPT Expert
- Messages: 2318
- Registered: July 10, 2014 - 11:52 PM
- Contact :
Hello, the database name is normally "wapt".
However, in our default configuration, the PostgreSQL database is not open at 0.0.0.0 and has no password or username.
You therefore need to modify the PostgreSQL configuration to open the PostgreSQL service to Power BI and create a Power BI user with a password who has access to the wapt database.
However, in our default configuration, the PostgreSQL database is not open at 0.0.0.0 and has no password or username.
You therefore need to modify the PostgreSQL configuration to open the PostgreSQL service to Power BI and create a Power BI user with a password who has access to the wapt database.
And to add to Simon's answer, it's read-only. You'll find what you need by following this guide:
https://www.wapt.fr/fr/doc/wapt-console ... sql-client
https://www.wapt.fr/fr/doc/wapt-console ... sql-client
Vincent CARDON
Tranquil IT
Tranquil IT
