Power BI

The latest updates can always be found in thePowerBI.CICD repository In the past I have been working on a lot of different Power BI projects and it has always been (and still is) a pain when it comes to the deployment of changes across multiple tiers(e.g. Dev/Test/Prod). The main problem here being that a file…

After Power BI Workspace setup – part 1, which was mainly about creating your workspace, giving it the right name etcetera, this blog will elaborate on workspace permissions. If you did not r…

Video by: Reid Havens Learn how to change the color of columns in a chart that are above or below an analytics line . RELATED CONTENT 🔗 Improved Dynamic Analytics Line Dynamic Analytics Line

At Excel, customer focus is at the core of what we do. We appreciate your feedback on adding autocomplete to data validation dropdown lists in Excel for Windows. Your Excel Community votes ensured this was one of the next in line to release after smooth scrolling. Thank you for keeping us honest and...

In my last post I showed how to use Log Analytics data to analyse Power BI query activity. The problem with looking at a long list of queries, though, is that it can be overwhelming and it can be h…

This article introduces the syntax to describe in a textual form the DAX expressions and additional properties of calculation groups. When calculation group

Deneb JSON Template for Joy/Ridgeline plot with independent scales

Introduction - Power Teleprompter I recently shared a teleprompter that I built using Power Apps and shared it with the community. Got some good feedback and suggestions that I wanted to try to incorporate into the app. Read on to know more about these updates! The original version of the teleprompt...

When a Power Apps form is very long a tabbed form design can offer a better user experience by making it more organized and easier to use.

I’ve listened to music on Spotify for over 5,000 hours since I subscribed to their service. I listen the most in the early morning when I’m at the gym and before my morning meetings beg…

Do you know who is the biggest "enemy" for the optimal data model size? Meet the Cardinality, and learn how to boost the report performance applying some simple techniques for improving cardinality levels

Starting with the next Power BI Desktop release, WebView2 will be required. If you have not switched over yet, please take action now to avoid interruptions.

Unless you’re building a solution for your exclusive personal use, you are not the customer. If you are not the customer, you need to invest in understanding the customer’s motivations,…

In this post (part of the "5 in 5" series covering 5 tips in a 5 minute read), I'll zoom out and look at 5 ways you can quickly update your app to let the UI breath. By helping the user focus on key actions in Power App, you'll have happier users and less problems to solve.

QuerySurge’s BI Tester provides connectors for Microsoft Power BI, Tableau, Microstrategy, IBM Cognos, SAP, and Oracle OBIEE.

How can you create your own data types in Excel? Oh yes, you can do it! In this article, we'll learn how you can create data types in Power Query.

When you want to compare two arrays, lists or tables in Power Automate and you might end up with a very slow flow. In this post the speedy solution.

Information The report shows the performance of the S&P 500 index which comprises 505 common stocks issued by 500 large-cap companies traded on American stock exchanges.  The report contains data for the last 1 year and is updated daily.   Data Sources The main source of data is Yahoo Finance. To pu...

If you aren’t using Tabular Editor to format all of your DAX code for you, you are missing out. I’ve written a super short script that will format all of your DAX code in measures, and make it look picture perfect in Power BI Desktop. First, you need to download Tabular Editor. The free version is

A handy feature of Tabular Editor is the ability to create C# scripts to simplify & automate basic development tasks. One such task that can be easily automated is the formatting of DAX code in the data model . Particularly upon inheriting a data model from someone else, formatting the DA

If you want to learn Tabular Editor, this is a good place to get started. This is a walk-through of some basic settings and uses of the tool, including how to find your way around and customize the user interface, and create, modify and organize objects in the model.

Recently I was asked about issues related to ambiguity in Power Apps code. In this post I will look at how to avoid any ambiguity issues in Power Apps.

Working with Power Apps Canvas is really nice, but I need code. The harsh raw code. Raw code makes my heart pump. Being able to read the code behind all the glossy click-drag-drop in the Power Apps Studio - that makes us understand on a quite new level.

Can we use a custom connector to make PowerFx available in PA now?

You don't even need to install Visual Studio Code and set up Git repository sync locally to access Power Apps source code, thanks to github.dev.

In Power Apps you can use data sources directly or you could use collections or you could use variables. But what is the difference?

Here’s how you can implement Error Handling by a custom Try Catch fashion.

Microsoft Power Automate is pleased to release the Business Leaders’ Guide to Robotic Process Automation (RPA) Migration whitepaper. Read this guide to help you evaluate your existing RPA landscape and develop a migration strategy that works.

This post gives a good overview of the different functionalities and design options of slicers in Power BI. For professional looking reports.

In this blog post I show you how to easily use Power BI Embedded and use your own reports to see what it looks like.