In the magical world, a wizard or witch’s hat and wig are essential items. They symbolize not only their identity but also their power and status. It’s no wonder that many are reluctant to share these prized possessions. However, the team who must not be named is setting a shining example for others by embracing the philosophy that sharing is caring.
This team goes out of their way to help and encourage other teams, earning them the prestigious Community Champion badge. Their willingness to share their hat and wig has made a significant impact, allowing other teams to visualize their teamwork and solutions more effectively.
Teams like SnitchOps, The team who must be named, and others have benefited from borrowing our equipment. This spirit of collaboration and generosity fosters a stronger, more united community. By sharing our resources, we not only help others succeed but also create an environment where everyone can thrive.
So, let’s follow the lead of the team who must not be named and remember that sharing truly is caring. Together, we can achieve great things and continue to support each other in our magical endeavors.
The Community Champion Badge celebrates going beyond our own goals to lend a helping wand to others. This time, the magic of collaboration brought us together with the enchanting team, The Broomstick Pilots, who sought guidance on harnessing the power of OneFlow.
A Knock on the Common Room Door 🚪💬
The Broomstick Pilots reached out, curious about our OneFlow setup and installation. With their inquisitive minds and an eagerness to learn, we knew we had to channel our inner Hogwarts professors to help them unlock the full potential of this amazing tool. 🪄
Spreading the Spell of OneFlow 📜✨
We gathered around and conjured a short but spellbinding introduction to OneFlow, showcasing how it can transform the way contracts are created and signed. Here’s what we shared with them:
Getting Started:
How to set up OneFlow in their environment.
Connecting it to their workflows with a sprinkle of Power Automate magic.
Why OneFlow is a Game-Changer:
Effortless collaboration on contracts before signing.
Seamless e-signature functionality on any device.
Tips and Tricks:
Integrating OneFlow with Dataverse for centralized contract management.
Using templates to speed up the contract creation process.
Encouragement:
We cheered them on to experiment and build something unique with OneFlow, assuring them they were just a few incantations away from something incredible. 🌟
Why We Helped 💛
At its core, being a Community Champion means embracing the true spirit of wizardry: collaboration, knowledge-sharing, and lifting others to greatness. The Broomstick Pilots’ excitement reminded us why we love working with these tools in the first place—it’s all about creating magical experiences together.
Spreading the Magic Doesn’t Stop Here
This badge is a reminder that every great wizard (or developer) started somewhere, and sometimes, all they need is a nudge in the right direction. Whether it’s a spell, a script, or a step-by-step guide, sharing knowledge makes the entire community stronger.
To @prosesspilotene (The Broomstick Pilots, it was a joy flying alongside you! 🧹✨ We can’t wait to see what magical solutions you conjure up with OneFlow.
A first time for everything. I want to learn new spells and want to try fabric and power BI for the first time.
Testing import data to Power BI desktop – With both data import and Direct Query.
Setting the Data source credentials to get the queried data to the Power Bi Service.
Test is working – Now lets wave the wand and build!
Fabric
HACK:
Got help from a team in the same house – HUFFLEPUFF POWER.
We can not get the trial to work in our tenant that we have for ACDC, so i had to create a service principal user in the ACDC tenant – and make it available multitenant. And then use this service principal in fabric in my work tenant to get the data in there.
We want to make a lakehouse with fabric, so after the data is clean, we can use it in Power BI and also share the data with other instances that needs to use the data.
Made a new Lakehouse: WizardData
Made the connection to the ACDC tenant
Cleaned the data:
Did this for all 7 tables.
I could not get compliant with the Power BI for my work tenant. So i decided to use Power BI desktop direct query to get the data from Dataverse and build a dashboard.
Start of dashboard: To be continued.
One last comment – We helped another team with the HACK to get the ACDC data into another tenant. COMMUNITY! – SHARING IS CARING!
Recently updates including two more badges: Crawler and Dataminer.
Api, datasets and code are handy tools to share. But as a PowerBI rooky, it can just as difficult to get a overview and navigate through the magic Power BI provides. Thats why I wanted to share some insight into this area to make it easier for those who comes after us.
We have been struggeling for hours to find a way to embed the PowerBI report as an interactive report in the app. With a free trail not all features are possible, and some workarounds are needed.
After a whole lot of tries and fails as you can see below…
… we managed to put a PowerBI tile in the canvas app, with the wanted dimentions to match our apps design.
After publising your report to PowerBI service the same report can be saved as a tile in a dashboard. Having the whole report in one tile will make the vizualisations interactive with each other – which is more user-friendly.
Embedding a Dashboard tile in the Canvas app was not the biggest issue – making it mobile friendly was a bigger problem. It was not possible to create a dashboard with a mobile display that could be embedded in the app. However, splitting one Raport into 2 Dashboard tiles seemed to be the best way to get the wanted result (visually), even though it was not as interactive as we wanted. But its good enough – as shown below.
Getting the data
Dataminer: We created our own data in SharePoint lists showing the House Cup Points, combined with the other lists. This created the base for exporting this data directly into PowerBI
SharePoint as datasource
Lists: Students, PointSystem, Houses, Professors
In the semantic model we configuredSchedueled refresh (every 6th hour), ensuring that the data updates often enough so the students can keep track of their progress.
The semantic model provided enough data to create the golden report we later embedded in the app.
Crawler: Search and AI in PowerBI report
In PowerBI we included this cool visual where the data is searchable simply by using natural language to ask what the data contains. This is a flexible way for users to access data even though it is not in any of the visuals.
Let us demonstrate:
Helping out
Walking down the hallway – I bumped into Sopranova struggelig with the same thing I just figured out how to do. Lending a hand and providing some guidance we managed to create a custom page with a embedded dashboard tile for their app.
We were very happy about that.
So if anyone else needs a hand in this spesific area we are happy to help:)
Greetings, fellow witches, wizards, and magical tech enthusiasts! 🧙♀️✨ The ACDC 2025 challenge is in full swing, and Team PowerPotters of Cepheo is casting more than just spells—we’re spreading joy and Hogwarts magic to everyone around us! From enchanting costumes to a community-wide Harry Potter quiz, here’s how we’re bringing the wizarding world to life and keeping spirits high.
🎩 Happy Campers: Living the Harry Potter Theme
To truly honor the magical theme of this year’s hackathon, we’ve fully embraced our inner Hogwarts students with:
Costumes: Decked out in capes, house scarves, and ties, our team has transformed into students straight from the halls of Hogwarts. Whether it’s Gryffindor, Slytherin, or Ravenclaw, our team is making the Harry Potter vibe unmistakable.
Magical Props: From our glowing fake fire to other wizarding decorations, we’ve turned our space into a mini Great Hall!
🧙♂️ Community Champions: Uniting Wizards with a Quiz
In the spirit of camaraderie, we hosted a Harry Potter-themed quiz for the entire hackathon community, using the official Harry Potter Trivial Pursuit game as our guide. Participants tested their wizarding knowledge with challenging questions like:
“What is the effect of the Diffindo charm?”
“What object hangs in the front window of the Knight Bus, periodically making comments??”
The quiz was a hit! It brought teams together for a moment of light-hearted fun, sparking laughter, debates, and a shared love for the wizarding world. And we received proof that the jurors (or aurors?) enjoyed it on the awesome ACDC Hogwarts platform.
✨ Why We Deserve the Badges
Community Champion
Proactive Engagement: By running a community-wide Harry Potter quiz, we went beyond our own team to engage and entertain everyone at the hackathon.
Positive Energy: The quiz created moments of connection between teams, adding a touch of light-heartedness to the intense competition.
Happy Camper
Themed Immersion: Our Harry Potter costumes and props created an immersive Hogwarts-inspired experience, bringing the hackathon theme to life.
Team Spirit: We’ve not only kept our team energized but have also shared that enthusiasm with others, inspiring participants to embrace the magic of ACDC 2025.
🔮 Spreading the Magic
With every cape swish and quiz question, we’re keeping the Hogwarts spirit alive at this year’s challenge. Whether it’s our costumes, props, or activities, Team PowerPotters is here to show that innovation and fun go hand-in-hand!
The Fabricator weaves once more, blending magic and technology.
Here lies a compendium of Hogwarts students, their traits, and achievements—crafted with care, or perhaps conjured from thin air. Gryffindor bravery, Slytherin cunning, Ravenclaw wisdom, and Hufflepuff loyalty, all woven into this digital tapestry.
But beware, dear wizards and witches: is this a truth etched into the annals of Hogwarts or a clever fabrication of the Fabricator? Dive in, but remember—what you find may enlighten… or enchant.
Is this data fabricated or real, only the Fabricator knows.
Here is a photo proof of that our fellow Gryffindor team, Pass me a sock, did use our data set.
PS:
Community Champion: Goes out of their way to help and encourage other teams as we went out to first find all Gryffindor teams (thanks to @scott we managed to find them all, or almost all…) and then offered the MVP team “Pass me a sock” our help or contributions, which they highly welcomed as we felt 🙂
Sharing is Caring: Code, dataset or api is made available for other teams and you do a sensible contribution(pull request, Integration) on a competing teams solution.
PS2: we did not stop just there but also went to another neighbor team Dumbledore’s Developers as we had some synergies in our solutions in terms of their relation to Sorting Hat… And although they are from the different #ravenclaw house, and we complete between houses also, we are here to have fun, aren’t we? Which is why we decided to share some of our data with them too, and they succeeded with their use case, which they described in the following post The Power of Collaboration | Arctic Cloud Developer Challenge Submissions
Having started the last lap of the race we want to share some of the fun we’ve had at camp. Both within our team and in collaboration with others. Having been placed in the centre of the room, it has been an utter privilege and an honor blasting mario tunes for everyone’s enjoyment.
We are all rocking matching outfits, even taking into account other people’s nostrils, by bringing more than one outfit!
Other notable features of the camp includes a lot of bananas. Cut-out bananas and 3d-printed bananas, of course! Wouldn’t it be easier to use actual bananas, you might ask. Well of course it would – but then we wouldn’t be able to have arts and crafts sessions!
Camp tour:
We have also given and received help throughout the event. Here are some photos of Herman helping INtendo DS with App Service config, and us receiving help with some prototyping:
