Forum Discussion
Connecting to Deltek Vision or Cosential?
Hi, I have a lot of experience connecting Power BI to Deltek Vision/Vantagepoint. What are you looking to do?
I've been tasked to create dataflows to our on-premises Deltek Vision databases. I can connect directly to the underlying SQL Server tables as I've done with other on-premises databases.
However, was looking to see if you or anyone has other preferred methods like using their API. It appears that there isn't a Certified Connection for it.
I'm interested in what you've done if you have a chance. Thanks!
If the client is using Deltek Flex First then the only way is to use the Hybrid Data Connection/ODBC. I use the api for coding Webservices and data integrations between systems. Thanks.
Thanks. The client is using on-premises Deltek Vision, version 7.6. Any suggestions for connecting with that setup?
Thanks
Aaron
Within Power BI Desktop, you can just enter the server name and pass through either your Windows credentials (if you have db access rights) or a username/pw. Once published, the destination server should be setup using an On-Premise Gateway. It'll pick it up from your connection in the pbix file and online to schedule it, you'll just need to make sure to "map" it to the destination under the gateway and it'll use the connection string there so you don't need to worry about it using your credentials or db username/pw.
