Coding for adding API key from Success Factors to Power BI

Hi elabach 

Thanks for the additional details.

Based on what you described, as per my understanding, it sounds like this may be a more complex authentication setup rather than a simple API token that can be plugged directly into Power BI, which could explain why the sample script isn’t working as expected.

If your LMS admin can provide the exact OData endpoint along with a ready to use Bearer token, connecting via Web.Contents in Power Query may be possible. If the private key is part of a multi-step authentication process, you may need a custom connector or another integration approach instead.

Given the firewall restrictions as well, I’d suggest checking with your LMS admin on the exact authentication flow and whether they can share a working sample API request. That should make it much easier to determine the right path forward.

If there are any deviations from your expectation please let us know we are happy to address.

Thanks.

Thank you for the follow-up post v-priyankata.  Yes, I did get the coding resolved using Raw (not JSON).