Tranquil IT Forum

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

Hello,
we don't use Microsoft products internally, so we won't be able to test anything.
Perhaps someone from the community can help you.
Have a good evening,
Bertrand

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

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.

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