Connecting Power BI to Deltek Vantagepoint API

[tsimpkins]

Hi,

I've been trying for about two weeks trying to bring data in from my company's Deltek Vantagepioint instance to Power BI. I've been attempting to do so throught the API but, I'm open to other suggestions of connection. I've created the API Authorization in Vantagepoint and I have the Consumer Key, Consumer Secret, DB Name, and Callback URL.

I've been trying to utilize Power Query to get a bearer-token but just hitting walls of errors. I've tried working through this with AI tools and any semblance of a guide I can find on the internet, but nothing is working. If anyone could pass on a good guide or info source, or knows anything about this process and would like to share their knowledge I'd greatly appreciate it. I am running out of places to look and questions to ask.

Thank you!

[Ericshep]

Hi @tsimpkins , is there a reason you're trying to use the API? Assuming you're on cloud, connecting via the Deltek ODBC would be easier and sufficient for most objectives in Power BI. We've connected Power BI to dozens of Vantagepoint instances and would be happy to walk you through it. Feel free to email me at eric@versionxsolutions.com

[v-hashadapu]

Hi @tsimpkins , Hope you're doing okay! May we know if it worked for you, or are you still experiencing difficulties? Let us know — your feedback can really help others in the same situation.

[v-hashadapu]

Hi @tsimpkins , hope you are doing great. May we know if your issue is solved or if you are still experiencing difficulties. Please share the details as it will help the community, especially others with similar issues.

[v-hashadapu · Accepted solution]

Hi @tsimpkins , Thank you for reaching out to the Microsoft Community Forum.

Vantagepoint’s API uses a strict OAuth 2.0 flow through Deltek’s identity service and this is where the difficulty comes from. Power Query can technically make HTTP calls, but it is not well suited to handling custom OAuth token exchanges, redirects and refresh logic unless the service is natively supported by Power BI. That is why attempts to generate and reuse a bearer token purely in M code usually end in cryptic errors or break once you try to refresh in the Power BI Service.

In practice, there are only two approaches that work reliably. The first is to place a very small intermediary (for example, an Azure Function or Logic App) that handles the OAuth handshake with Vantagepoint, caches the bearer token and exposes a simple REST endpoint for Power BI to call. From Power BI’s perspective this becomes a normal API call with a static header, which refreshes cleanly and predictably. The second option is to build a custom Power BI connector, where you can properly implement the OAuth flow and token refresh; this aligns much better with how Deltek expects clients to authenticate.