Power BI

With the public preview available for “Multi-Protocol Access” on Azure Data Lake Storage Gen2, now AAS can use the Blob API to access files in ADLSg2. Check how to do…

The use of Table.ColumnsOfType is unfortunately not as intuitive as the function may seem. I try to change this with this post.

Hello team, Today I am going to share with you a way that you can extend the functionality of your PowerPortals by using Durable Functions. First of all here are some links to the documentation in …

In an earlier post, I showed how to create a function that worked out if a date was a weekday or not. In this example, I've used that function to create a more complex function that adds a number of weekdays to a given date. In Power Query, go to the Edit Queries option and … Continue reading "Power BI: Creating an AddWeekdays function in Power Query M language"

If you are using Dynamics 365 Customer Engagement, you will no doubt have used Charts, Views and Dashboards to get a visual representation of your data.

Hi! Today I'm going to show you how to call a power query custom function from file in edit queries. You can now create a repository of custom functions and reuse them from there. Maybe in the near future we can have our m code more organized in our organization. This post will help us get throw thi...

Microsoft has developed a standardized set of schemas for the Power Platform they call the Common Data Model. The Common Data Model is an open-sourced definition of standard (“core”) entities that rep…

Have a guided experience, my third blog as part of my blog series regarding Storytelling with Power BI. During this blog series, I will elaborate on seven topic which can be used to apply storytelling…

Learn how to make Dynamica Visuals via buttons, bookmarks and Visuals to make a clean user experience. This tutorial helps you build better UI for users.

A centralized product launch resource enables clear communication between you, your team, and your customers.

I’ve just learned some really interesting new Power Query/M optimisation tricks! I’m going to write them up here as a series of worked examples rather than generalised patterns because I’m still tr…

Patrick looks at how to create and use a Power BI Hierarchy within Power BI Desktop. Hierarchies can help to provide correct data usage within your Power BI reports. Download sample Want to download t…

Today I had a look at the approval steps available in Microsoft Flow. I created a flow that created an approval step. Then I ran my flow and found the approval notification in outlook. However in the …

In this post, I will show you how to detect duplicate records/ items in Dynamics 365 CRM/ CDS/ SharePoint, delete the record/ item and send a list of deleted records/ items as an email attachment. We …

I was just working on a client project where we have several complex measures that reference other measures. Sometimes it can be hard to keep all these dependencies in mind. As a feature, it would be …

<p>For July PowerApps team released over 9 new features and enhancements for making your application creation experience even more productive, fun and a special focus for this month enabling Pow…

Forms Pro Survey records display information about the survey. A very quick and easy way to see all of this in one place is to use Word Document Templates.

As we head into August, we’ve released two feature updates for Paginated Reports in Power BI, with several more on the way.

Take our survey to help us continue to improve copy vs. export related scenarios in Power BI.

In July 2019 Power BI Desktop update they included new conditional formatting on table and matrix to include icons. These icons can be defined using SVG which is pretty cool. So this is a new post in …

This blog post follows on from Part 1 where I now demonstrate how to check in, check out, view previous versions or rollback versions of #PowerBI PBIX Files

Reading Time: 1 minute I recently added a Power BI “Blogmap” at https://powerbi.world/. The blogmap curates a list of Power BI-related blogs that I regularly follow. I’ve come to rely on it as a primary way to view current events in the Power BI world at one easy to recall URL. The Power BI Blogmap is based on the Google…

Reading Time: 5 minutes Data sonification uses variations in audio to hear differences in data values. From an accessibility standpoint, data sonification offers another potential avenue to enrich your reports beyond methods pertaining to data visualization. There are a few pieces that need to be assembled to enable data sonification that works in both Power BI Desktop and Service. While, audio…

<p>Using form header in model-driven PowerApps and Dynamics 365.</p>

<p>Unsaved changes dialog imnprovements</p>

<p>Timeline Wall usability improvements</p>

Introduction: Around 2014, an enhancement was made to the DAX engine designed to help improve query speed. The enhancement, called DAX Fusion, looks to reduce the number of storage engine scans nee…

As many data enthousiasts, I use Power BI on a daily basis to build dashboards and visualize my data. However, while building and…