Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
Our company is using Sage Pastel Partner, which stores data in a Pervasive PSQL database on prem. I am looking for some guidance in setting up a connection from Power Bi to this data.
I have tried using the Power BI connection PostgreSQL database, but I am not sure this is the correct connection to use or how to use it.
Please assist.
Rob
Hey Rob,
Yeah, it can be a pain. Pervasive is different from PostgreSQL which is pretty confusing. When looking up info on pervasive online it can be pretty confined.
I think if you use an on-premise gateway and connect via ODBC connector. So you can go and use a 32 bit power BI desktop app and add Pervasive.
Add a new data source and connect to ODBC and you should already have an ODBC connection to pervasive, use this one to add in a connection to the server. I have not done this myself but it's up and running where I work so it is possible.
Good luck, let me know if you have more questions.
Thanks,
Roberto
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.