Category: Uncategorized

Custom Timings in Viva Copilot reports

In Viva Insights, you can set up 2 Copilot reports; Adoption and Impact. I’ve created a custom report, that you can download from here, where you can change the time settings manually for the Impact report! This blog post is split into these sections, so feel free to scroll...

Endless calculations to the people

Well maybe not endless, but at least very, very, very, very many! Let me clarify slightly. Or if you prefer to just see what I created and test it yourself, click here! In Power BI, one of the biggest upsides is the ability for the user to interact with...

Task list automation with Power Query

I like when tasks are actionable. Saying “Fix the overview-page” as a task isn’t very useful to anyone! How do you know what to do and when you’re done? What if the task was instead “Decide on a name for the overview page”, “write a description for the overview...

Alternative to USERELATIONSHIP

From time to time you want to add RLS to your Power BI model. If you do, then the filtering option USERELATIONSHIP isn’t supported. Another scenario is that you filter on a date and you want to show things that has anything to do with that date, not just...

Listing all tables from Business Central

If you’ve ever worked with Business Central as your data source, you’ll know that you have 3 different endpoints to connect to. Within each, you’ll find tables of data. Sometimes, the table you’re looking for will be found in V2.0, other times in Odata (Webservices) etc. When you connect...

Parallel queries with Kolada

Let me just begin by saying that this solution is not something that 99.9% of the Power BI reports out there will have any use for as I honestly think it’s taking more time and calculations than you gain in most situations. In this very particular one it might...

Swedish housing shortage in Power BI

The Swedish National Board of Housing, Building and Planning, also called “Boverket” have published some open data on the housing shortage in Sweden. It’s a 45 MB Excel file and it’s supplemented with a view file where you can find a couple of pre-made tables to simplify the digging...

Trackmania Analyzer – Part 3 – Calculations

In this third and final blog post of the Trackmania series I’m focusing on the Calculations, both for columns as well as measures. Trackmania Analyzer – Part 1 – Using the report Trackmania Analyzer – Part 2 – Data Transformation This blog post covers the calculated table, followed by...

Trackmania Analyzer – Part 2 – Data Transformation

This is the 2nd part of my Trackmania Analyzer series and it covers technical aspects of how the data is loaded and transformed in Power Query. You can read the other posts here: The replay information is stored in .GBX-files. When transformed into JSON there’s a section for the...

Trackmania Analyzer – Part 1 – Using the report

This blog post covers the usage of my Trackmania analyzer that you can find on GitHub, so feel free to make use of this if you want to analyze your own replays! Other parts cover more technical aspects of the report and these posts should be considered if you...