Microsoft Power BI data connector for K-12

Jim Maier
Jim Maier
Ninth Anniversary Name Dropper Participant Facilitator 1
in SKY Developer General Discussions
Wondering if there is there a Power BI custom data connector for the K-12 ON product similar to the one for RE NXT. Or another way to connect to our K-12 site.

I have used blank queries to connect in the past. I have run into some error messages regarding missing tokens.

Thanks in advance for any replies.


Jim Maier

Comments

  • Matt Clemmens
    Matt Clemmens
    Tenth Anniversary Kudos 1 Name Dropper Facilitator 1
    Jim,


    Here is a rundown of the tools that my business partner Casey and I presented at last year’s conference - it outlines the steps to pull your advanced list data to PowerBI in a way that allows on-demand refreshes in the PBI desktop environment or scheduled refreshes in the PBI service.

    https://educatedinsights.com/bbk12uc


    More than happy to discuss in more detail if you want to ping me at matt@clemmensconsulting.com.


    Best,

    Matt
  • Jim Maier
    Jim Maier
    Ninth Anniversary Name Dropper Participant Facilitator 1
    Hi Matt,


    Thanks for the reply and information. Would you happen to know why one of the advanced list queries that gives me historical login records for students stopped at only bringing in 75k rows?

    Those were alphabetical by the student last name. The list had over 100k.


    Jim
  • Matt Clemmens
    Matt Clemmens
    Tenth Anniversary Kudos 1 Name Dropper Facilitator 1
    Sorry for the delay in getting back to you on this Jim.  I've seen a limit of 50,000 rows per list in my other pulls, so I build filters into the ON list to limit the number of rows, then combine the data in PowerBI.  We can pull multiple ON lists into PowerBI using separate queries as long as you turn off concurrent query loading, so this has provided a work-around on these longer ON lists.  Hope this helps!


    Matt

Categories