{"id":1700,"date":"2026-11-21T16:58:17","date_gmt":"2026-11-21T14:58:17","guid":{"rendered":"https:\/\/www.flip-design.de\/?p=1700"},"modified":"2026-11-21T16:58:17","modified_gmt":"2026-11-21T14:58:17","slug":"a-quiz-app-with-fabric-and-paginated-reports-in-a-web-app","status":"publish","type":"post","link":"https:\/\/www.flip-design.de\/?p=1700","title":{"rendered":"A Quiz App with Fabric and Paginated Reports in a Web-App"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">To be honest, the idea came from my wife. She said, \u201cI\u2019d like a quiz app, something like <em>Wer wei\u00df denn sowas?<\/em>, the German TV quiz show.\u201d<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">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\u2019t know exactly how to develop an app like that, so I turned to ChatGPT and Claude for help. I\u2019d 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.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The app uses a SQL database in Microsoft Fabric and an Azure service principal. I use a notebook to import additional data.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">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.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">There are still two messages I haven\u2019t been able to get rid of:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2026\/11\/image-2.png\"><img loading=\"lazy\" decoding=\"async\" width=\"940\" height=\"459\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2026\/11\/image-2.png\" alt=\"\" class=\"wp-image-1701\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2026\/11\/image-2.png 940w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2026\/11\/image-2-768x375.png 768w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2026\/11\/image-2-300x146.png 300w\" sizes=\"auto, (max-width: 940px) 100vw, 940px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2026\/11\/image-3.png\"><img loading=\"lazy\" decoding=\"async\" width=\"940\" height=\"459\" src=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2026\/11\/image-3.png\" alt=\"\" class=\"wp-image-1702\" srcset=\"https:\/\/www.flip-design.de\/wp-content\/uploads\/2026\/11\/image-3.png 940w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2026\/11\/image-3-300x146.png 300w, https:\/\/www.flip-design.de\/wp-content\/uploads\/2026\/11\/image-3-768x375.png 768w\" sizes=\"auto, (max-width: 940px) 100vw, 940px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">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.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">You can try the quiz app here: <a href=\"https:\/\/quiz-pbi-52942.azurewebsites.net\/\">Play the quiz<\/a><br><a href=\"https:\/\/quiz-pbi-52942.azurewebsites.net\/\">https:\/\/quiz: -pbi-52942.azurewebsites.net\/<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>To be honest, the idea came from my wife. She said, \u201cI\u2019d like a quiz app, something like Wer wei\u00df denn sowas?, the German TV quiz show.\u201d I started the project last year when I had a bit of spare &hellip; <a href=\"https:\/\/www.flip-design.de\/?p=1700\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1700","post","type-post","status-publish","format-standard","hentry","category-allgemein"],"_links":{"self":[{"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts\/1700","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1700"}],"version-history":[{"count":1,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts\/1700\/revisions"}],"predecessor-version":[{"id":1703,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts\/1700\/revisions\/1703"}],"wp:attachment":[{"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1700"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1700"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1700"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}