My Community
YourCause®
Impact Edge™
All-Star Lounge
Member Lounge (Just for Fun)
Community News
Community Manager
Groups
Browse Products
Members
Community All-Stars
Monthly Challenges
Member Search
Jobs Board
Help
Using the Blackbaud Community
Blackbaud Support
Knowledgebase
Blackbaud University
Discussions
Categories
Groups
Home
SKY Developer
SKY Developer General Discussions
Microsoft Power BI data connector for K-12
Jim Maier
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
Find more posts tagged with
Comments
Matt Clemmens
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
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
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
Quick Links
All Categories
Recent Posts
Activity
Unanswered
Groups
Help
Best Of