Power BI

This article explains the precedence of calculation groups in DAX, needed whenever multiple calculation groups are present within the same model. Before sta

This is not so much a DAX tip, rather something you might consider if you want to speed up the performance of any Direct Query (DQ) model you manage in Power BI or Analysis Services. The simple tip…

Have you ever tried to sort an array or collection in Microsoft Flow? Did you ever look for the Sort function when you build your expressions? You can stop searching! It doesn't exist. The Sort Azure …

Previously, I wrote a post called Microsoft Flow & Quick Parts, which shows how you can insert fields from SharePoint into your document via Flow and Quick Parts. Many times in business processes, thi…

New gateway management features on Admin center

It's been a long time coming, but I'm super excited that Power Query Intellisense and Highlighting features are finally here in Excel!

<p>The Power Platform Admin Center now lets any Gateway administrator manage their On-premises Data Gateways.</p>

Adam shows how you can use the Power BI REST API without writing any code. Then takes it to the next level with PowerShell. Power BI REST API Reference – https://docs.microsoft.com/rest/api/power-bi/ …

There are many scenarios that you might want to implement a conditional expression. When the conditional expression's logic is on a row-by-row basis, the best is doing it in Power Query rather than DA…

By In this article, I want to show you the cheat sheet of the Shared Dataset inside Power BI. I tried to cover all the information related to shared dataset. As you know, the Shared dataset is one the…

This post introduces how sharing a canvas app using CDS to a security group now supports a streamlined means to set the CDS security role on the security group.

In Chapter 11 of my book, I introduced the Cartesian Product technique that enables you to combine two datasets in order to apply a calculation or filtering on each combination of paired records. In t…

I used to work on a full-text search engine. Back then, we often paraphrased a famous Albert Einstein’s quote “Organized people are just too lazy to search”. In Power BI Desktop you can search for tab…

Having the capability to connect external people (B2B) into your data within Power BI is a great feature and a huge advantage when comparing to other customers in my opinion. In this blog post I want …

Although very simple, still I see many Power BI reports with no organized way of separating measures. When you use Power BI for a while, you will gradually have more DAX measures and calculations, and…

In this month’s PowerApps Community call we will discuss and demonstrate common PowerApps development techniques.

When you have a large array of data and and the data has duplicates, it can be difficult to to de-duplicate your data in PowerApps. There is a Distinct function which returns a unique list of value…

Thanks for watching this week’s Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup144 Tech video: https://guyinacu.be/appsandworkspaces Sources Slicer with Histogram in Power BI (@ExceleratorBI) The Dynamic Time Matrix (@PowerBITips) Sending refresh notifications to others On-premises data gateway July 2019 update is now available Multiple data source definitions on the On-premises data gateway for the same […]

While there is a native function to fetch text between 2 delimiters in Power Query, there is no such function that removes the text instead. Therefore I’ve created a custom (…) Read more

<p>AppSource certification readiness </p>

<p>Dynamics and PowerApps ISVs can now see a consolidated view of your published Dynamics Customer Engagement apps with cross tenant application insights to monitor and support your apps. You ca…

Power Query is now available inside of Excel for Mac. These are my first impressions and performance tests that I've done with this integration.

The purpose of this post is to share and describe a Power BI-based solution for analyzing SQL Server Agent job history data. SQL Server Agent has been around for many years and though increasingly my …

Join Pragmatic Works for the only 100% virtual conference dedicated to the #PowerPlatform on July 23rd and 24th... Looking to enhance your Power BI, PowerApps and Flow skills but can’t attend an in-pe…

June was yet another exciting month for Power BI! Read on for a summary of the announcements we made in both the service and mobile.

Recently in Power BI, a new feature was added for Paginated Reports e-mail subscriptions where you could optionally add a preview image in the body of your e-mail message. By default, this is…

Hi Office International Community members, Did you ever want to measure wind speed from an anemometer? Or model the impact of the brain colliding with the skull? Even determine the electroconductivity of a solution? Excel’s Data Streamer Add-In supports capturing, visualizing and analysing real-t...