Best Practices for Loading Sprinklr Data into Power BI for Reporting

[Glo2002]

Hi everyone,

I've been tasked with integrating Sprinklr with Power BI (either via APIs or alternative methods) so that I can connect Sprinklr data with other data sources in Power BI. The goal is to load the data (not just a live connection) to be able to run queries and generate reports.

Could anyone guide me on how to set this up?

Thanks in advance for your help!

Best regards,
Glo

[rajendraongole1 · Accepted solution]

Hi @Glo2002 - Best practices documents and links:

Microsoft Power BI and Sprinklr Integration and Automation (tray.ai)

• Use tools like Postman to test API calls first, ensuring the correct endpoints and data format.
• In Power BI, you can connect via the Web connector. When prompted, use the API key for authentication. Note that sometimes you may need to use basic authentication by placing the API key in the username field (depending on Sprinklr’s API setup).

Hope this helps.

[Glo2002]

It sure did, thanks!

[v-linyulu-msft]

Hi,@Glo2002 
We are very glad to know that the issue has been resolved. If you wish, consider accepting rajendraongole1's  solution as a solution that will also benefit other community members who have the same problem as you and find a solution faster.

Of course, if there is anything else we can do for you, please do not hesitate to contact us.

Looking forward to your reply.

Best Regards,

Leroy Lu