Using Wonde to feed Power BI

[Ted2424]

Yes im writing the codes in blank query in pbi according to this guide Wonde Integration with Power BI using the API | Power BI for Schools which was also reccommended as a useful link by Wonde. Followed all step and still got the mentioned errors. Im opened to suggestions if there's another method entirely. Just want to get data into pbi from the api for further analysis.

 

Queries from where - do you have some code written somewhere in PowerBI itself, or are you using an external-to-PowerBI script / application to get the data and pass it to PowerBI in some way?

[Marci]

I'm inclined to suggest: contact the author of the guide you're following, Dave Potts, who provides bespoke training as well as fixed packages around PowerBI / Analytics.

 

https://www.schoolanalytics.co.uk/purchase-options/

[PotNoodleTech]

Interesting - what extra security have you implemented to guard against losing data? Wonde seems to sync *.* from the MIS and then its down to the app itself to pull whatever data it needs (or is supposedly allowed to pull). If your DIY method gets hacked you could breech all your MIS data in one go? (I mean it's no different to Classcharts I suppose other than the responsibility would lie with you directly not a third party?)

[jthompson]

Interesting - what extra security have you implemented to guard against losing data? Wonde seems to sync *.* from the MIS and then its down to the app itself to pull whatever data it needs (or is supposedly allowed to pull). If your DIY method gets hacked you could breech all your MIS data in one go? (I mean it's no different to Classcharts I suppose other than the responsibility would lie with you directly not a third party?)

 

In the Wonde developer console you eed to speicfy which MIS fields your app can access. A least privilege approach here seems sensible, and Wonde need to approve any changes you make to that. On the receiving end, if the data is being fed into a spreadsheet, SharePoinit list, etc. then taking care over privileges to those files ought to cover most of it. If those are living in M365 then you can rely on whatever account security is already in place.

 

An important point to consider is the security of the Wonde API key, since you don't want that lying around. Where we're querying Wonde using on-prem PowerShell scripts, we store the API key in a SecretStore vault to keep it out of plaintext as much as possible.