Power BI

Power BI APIs can support you at any scale, but there is no one-size-fits-all API. The ExecuteQueries API is a great choice at small scale. For large-scale solutions, switch to XMLA endpoints and host your datasets on Power BI Premium.

Use products table to find missing values in the fact table. Find Missing Products that did not sell.

List.Accumulate is a powerful function that allows you to perform transformation multiple times. Learn how its use can save you many steps!

On the surface it may look like Microsoft’s data gateway provides an even playing field between IaaS and PaaS approaches with regards to SQL hosting, i.e. you can run your database server in …

I’ve been spending time lately trying to get a deployment pipeline to work for one of my clients and ran into a couple of non-intuitive limitations that I didn’t expect, so I thought th…

The improvements to the Power BI experience in Excel include a new user-friendly UI that helps users easily search for datasets to build reports in the Excel grid. Also, users can now directly navigate from Excel to the Power BI service to discover new data artifacts in their organization or get additional insights from Power BI reports.

Some time ago I wrote a post about how optimising for CPU Time is almost as important as optimising for Duration in Power BI, especially if you’re working with Power BI Premium Gen2. This is …

This article describes how to hide measures from a group of users by leveraging object-level security in Power BI and Analysis Services. Power BI datasets a

Work: 17th Century Watercolors

Its about the clusters. I have created a scatter chart with the measure of Profit Margin and Revenue of y and x axis respectively.

Creating a calendar is not as complicated as you think. It requires some creativity and you could achieve it too.

You may have used the UNICHAR() function in DAX to return Unicode characters in DAX measures. If you haven’t yet read Chris Webb’s blog post on the topic, I recommend you do. But did yo…

Check this simple trick to enhance the user experience when using Fields parameter feature in Power BI

Conditional formatting is an easy way to highlight values so report users can receive quick insights on the status of key metrics. In this post, I will be showing a way to apply dynamic conditional formatting on visuals with set thresholds. This will...

Power BI is full of hidden gems! This one can literally make you a real Power BI hero out of nowhere!

Data literacy is the ability to read, understand, and use data to drive decisions. Find your data literacy persona by taking this assessment.

Presenting data with empathy and context leads business users to better decision-making.

The SWITCH function in DAX has been optimized over the years, and it is helpful to know what makes the optimization work best. The SWITCH function in DAX is widely used to define different execution paths depending on the condition of an expression. A very common case is when we want to check the sta

Read MoreTop Considerations for Delivering an Efficient Hybrid WorkplaceOver the last two years, the importance of optimizing efficiency and productivity in the Hybrid Workplace has become an …

Best practices for reusing dataflows across environments and workspaces

Learn how Power BI self-service data preparation is about using dataflows to centralize data cleansing and transformation work.

Creating custom visuals using the Charticulator in Power BI is not easy. So here are some some Charticulator resources I've used to skill up.

This post explains what report level measures are, when, and how we can use them in a Power BI thin report.

Finding the main bottleneck in your Power BI report may be a challenging task. Learn how to quickly identify the poor performing report elements and how to improve the overall performance by applying some clever tricks!

Hey folks, if you know me, you probably know I am very interested into playing, watching or talking about football (or “soccer”). After decades my home club finaly reached again the seventh German ‘Bezirksliga’ and a German community platform and news publisher “FuPa.net” about amateurs football was looking for suggestions how to split the league. So I decided to make my suggestion and building a Power BI report to help me and also make it visual. Today we will learn about the German football leagues, Power BI, Geocoodinates and how to calculate distances, Power BI Bookmarks, how to use custom functions and make API calls in Power BI and to get some webbrowser content using Power Automate Desktop.