Power BI

Welcome to the Power Apps Coding Standards For Canvas Apps. This guide has over 50 pages of coding rules, guidelines & best practices

Last Friday, September 16th, Microsoft introduced Name Formulas to Power FX. Named Formulas, and old concept that has been part of Microsoft Excel for a long time has now been brough to Power FX (currently experimental only). With Named Formulas we can simplify app initialization, reduce load time and logic and improve overall app maintenance

A topic that I find particularly interesting with developing low code software on the Power Platform, is the thought we put into our end users experience of interacting with our solutions. A very key element to the scale at which users confidently and willingly adopt our application with high usage,

easy hack on how to get an faux auto height property for controls that usually don't have one

One of the fundamental things missing from Power Bis visualisation capabilities is the ability to easily control data labels. Having to resort to hacks is not ideal but if good data visualisation i…

I'm going to start this blog post with a very strong statement: Bookmarks are the best thing since sliced bread! Yes, I know some of you are not a fan of this incredible feature, but hopefully I can change your mind with this blog post. I feel that for you to like bookmarks, you really need to know all the ins and outs of it, otherwise it can be quite overwhelming, specially if you have to create loads of bookmarks in the same report. First, a little definition of what are bookmarks in Power BI:

Something I do all the time when performance tuning Power BI is use SQL Server Profiler to monitor query and refresh activity. There’s a handy external tool that lets you open up Profiler wit…

Deep dive into Analysis services 2022 new features deep dive part 1: Composite Model and DAX

A new feature for Deployment pipelines, Deployment History, allows you to review details of all your recent months deployments – who, what and when. Check it out! Also, download our Azure DevOps extension now having general availability, and be aware our UpdateApp API now excludes adding new items to Apps.

Welcome to Azure Data Factory’s September monthly update! Here, we’ll share the latest updates on what’s new in Azure Data Factory. You can also find all our updates on our What's New in ADF page.    We’ll also be hosting our monthly livestream next week on October 11th at 11:30am PST/ 2:30pm EST! J...

Hello Power BI community, Something amazing is coming! and we need your help to transform the future of data visualizations in Power BI. Our goal is to learn…

Welcome to the Power Apps monthly feature update! We will use this blog to share a summary of product, community, and learning updates from throughout the month so you can access it in one easy place. A variety of new and highly anticipated features are now available which we are very excited to share. These … <p class="link-more"><a href="https://powerapps.microsoft.com/en-us/blog/whats-new-power-apps-september-2022-feature-update/" class="more-link">Continue reading<span class="screen-reader-text"> “What’s new: Power Apps September 2022 Feature Update”</span></a></p>

We’re excited to announce the initial preview of Test Engine, an evolution of our Power Apps testing tools. Test Engine builds upon the key use cases of Test Studio, but takes it in a new, powerful direction through open source collaboration and use of the Playwright browser testing platform. The goals of Test Engine are to provide customers with a robust testing platform for all types of Power Apps, and to make it super easy to integrate automated testing into your app development processes.

This blog post shows you how to use the DAX function EvaluateAndLog and how to use the DaxDebugOutput app with Power BI to view the results

I love Power BI community for the inspiration it gives. Today after reading this LinkedIn post by Jan Schroeven I realized that if Power BI … Read More

Recently I had an interesting use case where I had to a compound calculation in Power BI. You can compound an interest rate for example, where you get a certain rate on your savings. Let's say 1% (which is at the time of writing ridiculously high, but bear with me). After 1 year, you get 1% interest

Explore a few proven strategies for setting up workspaces for your Power BI Premium Per Capacity (PPC) in this insightful blog. Read today!

If you’ve worked in tech for 25 years, you’ve seen some stuff, and you’ve learned a lesson or two. On October 1st, I presented a new session at Data Saturday Atlanta, sharing the …

I love the Power BI community. There are so many great things that the community does. They help each other (think the Power BI community forum) and they also build fabulous third party external tools to enhance Power BI. Measure Killer This week I am sharing a brand new third [...]Read More »

Power BI is a powerful tool that has also enabled millions of people worldwide to easily visualize & explore their data. Despite that, inflexibility to the visualization configuration and formatting can make it difficult to fulfill visual requirements. What are some of the biggest feature g

Here’s our September release of the on-premises data gateway! As always, stay up to date for the latest functionality.

Tool for deleting all photos from the Google Photos - GitHub - mrishab/google-photos-delete-tool: Tool for deleting all photos from the Google Photos

In this blog post, we will discuss what is the PowerApps Parse JSON function, how to use, and how to extract information from the JSON to use in PowerApps.

✨A new DAX function that is already available in the September release of #PowerBIDesktop, but was hidden in the last updates announced in September. ✨#OFFSET allows to make comparisons in context between two values, without writing extremely long and complex

Blogging about Power BI, Power Platform and other things I find interesting.

In September 2014, I wrote a blog post on dynamically passing parameters from PowerPivot to a SQL Server stored procedure using VBA. Back then, VBA was a real lifesaver. It perhaps still is for many of us. But frankly, I even forgot how to write VBA. Maybe it is time to look at it again. … Continue reading Dynamically Passing Parameters to a SQL Stored Procedure in Excel 365 Using Power Query

Time to read: 5 minutes Have you ever wanted to search through your Power BI measures, calculated columns or calculated tables for a specific function or table/column reference? Or export your DAX logic for documentation purposes? If this is the case then this post is for you. As a Power BI dataset admin or author, ... Read more

Over the past few days, I attended the Power BI Next Step conference in Lego land – Denmark. During the keynote, Will Thompson – PM on the Power BI team, showed a new DAX function that …

In my last post I went over using a Service Principal account to access a Synapse SQL Pool with Power BI. I even showed how you could go across different tenants in my example. In this post instead…

Have you ever wondered how people do the trick below? Say no more! I'm going to share with you all the tricks that you need to do to achieve something like this. In my example, I created a report where you could switch the measure the charts were showing, and with that, the color of the charts and KPI cards changed to. The first thing you need to do is create your base measures. In my example my base measures were: Number of Orders = count(Amazon[Order ID]) Orders Value £ = SUM(Amazon[Amount]) I