Skip to content

Uncategorized

Task list automation with Power Query

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 page” and “accept the description of […]

Alternative to USERELATIONSHIP

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 the primary relationship connection. OK so […]

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 to BC you need to select […]

Parallel queries with Kolada

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 make sense though, so let’s have […]

Structure in Teams

Structure in Teams

Just as there are many ways to decorate a house, the same goes for a team*s collaboration “rooms” in Microsoft Teams. 💡One of the best tips I learned from my boss @Ståle Hansen, was to set a default order of apps/icons in the left side menu in Teams. This makes it easier to communicate whenContinue reading “Structure in Teams”

Swedish housing shortage in Power BI

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 through the data. Naturally, I could […]