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.

Im having issues with the queries to get the data from the API into powerbi. Different errors like "cannot convert value 1999 to type Text" and 'Column1 of the table wasnt found' while trying to get attendance mark. Also im needing data for 3 different schools as the dashboard is for a MAT, do i call it separetely or is a a function/line of codes that dies this. Will really appreciate if anyone has done it from the scratch to guide. Thanks for your time.

Any elaborate process of integrating wonde api with powerbi will be helpful. anyone?