A Quiz App with Fabric and Paginated Reports in a Web-App

To be honest, the idea came from my wife. She said, “I’d like a quiz app, something like Wer weiß denn sowas?, the German TV quiz show.”

I started the project last year when I had a bit of spare time. I built the first version on a virtual machine running SQL Server and SQL Server Reporting Services. I then wanted to build the quiz app using Microsoft Fabric and Power BI Embedded. I didn’t know exactly how to develop an app like that, so I turned to ChatGPT and Claude for help. I’d bought a ChatGPT Pro subscription myself, and my company gave me access to Claude. With their help, building the app turned out to be fairly straightforward.

The app uses a SQL database in Microsoft Fabric and an Azure service principal. I use a notebook to import additional data.

Reporting Services is, of course, a reporting tool. I wanted to see whether I could use it to build a quiz app. Since the app needs to write a lot of data back to the database, I was particularly interested in finding out whether that would work with Reporting Services.

There are still two messages I haven’t been able to get rid of:

With the technology I chose, I have to live with those two messages. The layout also scales better on some devices than on others. My goal all along was to play the quiz on a tablet or a computer, and it works really well on both.

You can try the quiz app here: Play the quiz
https://quiz: -pbi-52942.azurewebsites.net/

Categorized: Allgemein

Comments are closed.