Browsed by
Author: admin

Monitoring Power BI Report Server Execution Status with a Paginated Report

Monitoring Power BI Report Server Execution Status with a Paginated Report

Comments 0 Comment

Keeping an eye on your Power BI Report Server jobs can be a bit of a black box—until now. To make monitoring easier, I’ve built a paginated report that lists all ReportServer jobs, including both automated data refreshes and subscriptions for paginated reports. Big thanks to P. Theriault for the error criteria inspiration and to Alexander Korn for laying the groundwork with the base view! What the Report Does The report pulls job execution data from the ReportServer database and…

Read More Read More

Solution for ReportServer error “Folder contents could not be loaded” via Reverse Proxy

Solution for ReportServer error “Folder contents could not be loaded” via Reverse Proxy

Comments 0 Comment

When exposing a Power BI Report Server (PBIRS) to external users over the internet, the typical setup involves placing it behind a reverse proxy. This allows for SSL termination, clean URLs, and better control over access. If you’re unfamiliar with reverse proxies, here’s a good overview: Reverse Proxy – Wikipedia. In our setup, everything worked fine when accessing the ReportServer directly from the internal network. But as soon as users tried to access it via the reverse proxy from the…

Read More Read More

From SQL to Python: A BI Engineer’s Certification Adventure

From SQL to Python: A BI Engineer’s Certification Adventure

Comments 0 Comment

Disclaimer This article was created based on my personal notes with support from Microsoft Copilot. While Copilot assisted in structuring and refining the content, all technical details have been carefully reviewed and developed by me. Yep, the title image has a typo…thanks to the creativity of Copilot…life is sometimes imperfection 😜. Thanks for the photo to Jason Leung on Unsplash . After six months of steady learning—roughly 30 minutes a day, almost every workday—I’m proud to say I’ve officially earned…

Read More Read More

Setting Up a Local Power BI Report Server Demo Environment

Setting Up a Local Power BI Report Server Demo Environment

Comments 0 Comment

Disclaimer This article was created based on my personal notes with support from Microsoft Copilot. While Copilot assisted in structuring and refining the content, all technical details have been carefully reviewed and developed by me. So, I’ve got a talk coming up about Power BI Report Server, and naturally, I needed a local test environment to play around with. I figured I’d document the setup here—not just for my own future reference, but maybe it’ll help someone else out there…

Read More Read More

Exploring Many-to-Many Modeling Between Fact and Dimension in Power BI: What I Learned

Exploring Many-to-Many Modeling Between Fact and Dimension in Power BI: What I Learned

Comments 2 comments

Disclaimer This article was drafted with the help of Copilot (AI) – so if it is unusually well structured or my English sounds unusually polished, that’s probably why 😊. I’m not a DAX expert (yet), and the DAX code used here was generated by Copilot too. It worked well for testing, but I’d recommend reviewing it thoroughly before using it in production. The test reflects my specific use case – a many-to-many relationship between a fact and a dimension table. Your scenario might differ,…

Read More Read More

SVG Filters and more SVG crazy stuff at Workout Wednesday 2024_30

SVG Filters and more SVG crazy stuff at Workout Wednesday 2024_30

Comments 0 Comment

A new week comes with a new excercise of Workout Wednesday by Kerry Kolosko: Now SVG Filters. Here are my learnings from this excercise. Grab my solution PBIX here, in case you are interested. This exercise was somewhat exotic to me…not only that I have just learnt about Deneb now we are doing visuals as SVG…so it shortly ocurred to me : “Why on earth are the Power BI core visuals not enough?”I am really skeptical if I would go…

Read More Read More

(Failed) Segmented Bar Chart
(Failed) Remake of a Tableau Segmented Bar Chart

(Failed) Remake of a Tableau Segmented Bar Chart

Comments 0 Comment

I tried to do the Workout Wednesday Exercise of week 29 but oh boy…this was far to difficult for me.Here’s the PBIX of the failed solution and finally the PBIX of the follow-along-successful solution 😉. Failed approach Data prep and DAX measures I thought were straightforward. I ended up creating a measure for sales for each year and a measure for total sales…sure there are more elegant ways to have this more generic and not have to create a measure…

Read More Read More

Scatter plot showing the path of selected data points

Scatter plot showing the path of selected data points

Comments 0 Comment

Another week with Workout Wednesday: This is my take on the exercise for week 27/2024 which is about scatter plots with paths. The challenge is from Bernat Agullo and uses interesting open data from the website Gapminder. I found it very helpful that Bernat provided a written step-by-step guide and I later discovered his video as well. You can download my solution here. So let’s delve in the new things from my perspective. Join Data in Power Query We start…

Read More Read More

Theme Sentiment Colours with Power BI

Theme Sentiment Colours with Power BI

Comments 0 Comment

WoW 2024_26 Today I worked on my first submission to Workout Wednesday. Okay it’s technically Thursday here in Germany but more important I managed to do the whole thing. I chose week 26 which is about Reference Theme Sentiment Colors in DAX and practiced how to design a dashboard in a way where color scheme changes are reflected automatically in the formatting of the visual. I would like to share my personal learnings in a short bullet point list. This…

Read More Read More

Getting Schema Spy to run on databases with lots of tables

Getting Schema Spy to run on databases with lots of tables

Comments 0 Comment

The other day I ran into issues with Schema Spy pointing it to a database with 1.200 tables for the first time. The problem The error output was the following: Writing/diagramming detailsINFO – Completed summary in 277 seconds INFO – Writing/diagramming details .Exception in thread “main” java.lang.reflect.InvocationTargetException at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:119) at java.base/java.lang.reflect.Method.invoke(Method.java:578) at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:48) at org.springframework.boot.loader.Launcher.launch(Launcher.java:87) at org.springframework.boot.loader.Launcher.launch(Launcher.java:51) at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:52) Caused by: org.schemaspy.output.diagram.RenderException: Failed to generate Table diagram at org.schemaspy.output.diagram.TableDiagram.generateTableDiagram(TableDiagram.java:24) at org.schemaspy.output.html.mustache.diagrams.MustacheTableDiagramFactory.generateRealTableDiagrams(MustacheTableDiagramFactory.java:93) at org.schemaspy.output.html.mustache.diagrams.MustacheTableDiagramFactory.generateTableDiagrams(MustacheTableDiagramFactory.java:57) at org.schemaspy.SchemaAnalyzer.generateHtmlDoc(SchemaAnalyzer.java:488) at org.schemaspy.SchemaAnalyzer.analyze(SchemaAnalyzer.java:289) at org.schemaspy.SchemaAnalyzer.analyze(SchemaAnalyzer.java:135) at…

Read More Read More