Snap as a MS Power BI data source

Snap as a MS Power BI data source

How can I import a Snap app database into Power BI?

  • 14 June 2020
  • SOTI Snap
  • 2 Answers
  • 1 Upvote
  • 3 Followers
  • 2.3K Views
    • 2 Answers
    • 1 Upvote
    • 3 Followers

2 Answers

Order By:   Standard | Newest | Votes
JVMOD@SOTI | posted this 15 June 2020

Hello Alejandro,

 

 Thank you for your post, I will research on this and will get back to you.

 

Regards,

Technical Support | SOTI Inc. |1.905.624.9828 | support@soti.net | www.soti.net |

  • 0
  • 0
SMod@Soti | posted this 15 June 2020

Hey Alejandro,

Great question, there are multiple ways to achieve this. Let me summarize them:

1. Use Snap developer APIs available here. Using the app level APIs (details available under API Details when clicking on three dots for an app in App Manager screen), you can get all the data collected by an app at that time, by one simple API call. Then you can feed this data into Power BI report.

2. Use Power BI REST APIs as a REST Data Export in Snap app. This will directly send the data (per record) to the BI and can be handled in data sets.

3. Use REST APIs to sync Snap data into your local SQL (or any other) database which can be used as a source for your BI report.

 

Let me know if there are any questions. 

 

Thanks

Technical Support | SOTI Inc. |1.905.624.9828 | support@soti.net | soti.net |

 

  • 1
  • 0

Give us your feedback
Give us your feedback
Feedback