SOTI Pulse Logo

Connect SOTI Snap App to Power BI via Rest API

TK
Thorsten Konrad
essmannsbackstube

Hello everyone,

In order to create reports and dashboards from the data collected in a Snap App, I would like to access it via the Rest API with Power Bi. However, I am having problems configuring the API call in MS Power BI. Have any of you done this before and can give me a tip on how to proceed?

Many thanks for your tips in advance!

OK - i made some progress. 

Do any of you know where I can find the entryID?

Do you know how I can design the query so that I can query all database entries, because I would ultimately like to compile a report from them

Microsoft Power BI using Snap´s Restapi
a year ago
SOTI Snap
ANSWERS
DK
Deepak Kumar
a year ago

Hello Thorsten, you can locate the entry ID in the report section. This unique ID is assigned to every record created in SNAP.

A
ABMOD@SOTI
a year ago

Hi Thorsten Konrad,

 

Thanks for posting on SOTI Pulse, Thanks Deepak Kumar for responding to the post, your expertise and willingness to help are greatly appreciated!

Have you had an opportunity to test the suggested solutions by Deepak Kumar, and has it successfully addressed your query?

If not, or If you have any additional questions or concerns, please don't hesitate to reach out. We're dedicated to providing assistance and support.

TK
Thorsten Konrad
a year ago

I think I now know where my main error lies, which is why I'm not getting anywhere. PowerBi only processes GET requests. But to embed the bearer token I need a POST request according to the API explorer. Does anyone know a solution to process the topic in a GET request? Perhaps someone has already built a connector with which I can work around the problem? Thanks for any tips in advance!

DK
Deepak Kumar
a year ago
A
ABMOD@SOTI
a year ago

Thanks, Deepak Kumar for responding to the post, your expertise and willingness to help are greatly appreciated!

Similar Discussions