Power BI

The new Power Automate Pane offers improved integration between Power Automate and Power Apps canvas apps. Create, edit, and refresh flows directly inline with the canvas app authoring experience.

Introduction: The Canvas App provides us with a visually rich representation of our data for mobile devices. Recently while trying to incorporate functionality in the Canvas App we needed a way to parse JSON. In the quest to find an appropriate approach for the same, we got to know that we can d

In this article I will show you the best workaround to view a PDF file stored in a SharePoint document library inside Power Apps.

My presentation from Teams Nation 2022 event on the use cases for Dataverse for Teams based Power Apps inside Microsoft Teams environments.

The new AI Builder’s explore page is available. This new page provides clearer, useful material to get started with AI Builder.

Automating your routine tasks has now become a more fundamental part of our work and our organizations. Therefore we’re bringing easy to use workflow automation powered by Power Automate directly within the Teams Store.

In this post, we will look at App Side Panes in Model-Driven Apps, a useful feature that gives users a side pane on the right side of a model-driven app. Developers can utilize this pane to display information to a user, such as lists, records, and pages. Note, according to the documentation, this is still in preview and was expected to go GA last month. Keep an eye out for … Continue reading App Side Panes in Model-Driven Apps

If you use a lot of galleries in your Power Apps, you may have noticed that it can get tedious sometimes, lining things up and arranging controls, especially when you want your gallery to look more…

We are happy to announce that we have just released the April 2022 update for the On-premises data gateway (version 3000.122.7)

Engage with experts and peers in the Dynamics 365 community forums

A cheat sheet with all 150+ Power Apps functions with links to the official documentation and also some hidden undocumented functions

From time to time you may be forced to deal with JSON objects in Power Automate that contain duplicate property names. Consider this object, for example: { "Id": 42, "Name": "Fixing the machine", "From": "Edison", "Total": 1000, "Items": [ { "Id": 1, "Name": "Hammering",

Learn how Azure Functions can help build robust serverless apps.

In a previous blog, I showed that dual Mode is really a very good pattern when building PowerBI Model that uses Direct Query, but it in order to work, both Tables needs to be using the same Data So…

Taking Lists from foe to friend. Lists in Power Query are something many people know nothing about. Power Query uses them all the time even though you may

Paginated Reports have been available in Power BI since 2019.  They serve an important purpose, but they are not easy for the average business user to learn, plus they require Power BI Premium to use.  In my blog and video today, I will show you how you can use Excel [...]Read More »

Recently, we hosted Allision Kennedy on the Raw Data by P3 Adaptive Podcast. During the course of the conversation, our co-host Thomas LaRock expressed

A Gantt chart is an excellent example of where Paginated Report & SSRS were an ideal choice for the purpose. It is a running list of activities with the duration for each displayed as a horizo…

In this blog post I will be sharing a PowerShell script that allows multiple Power BI reports to be downloaded at once. In the Power BI service, there is no way of downloading multiple Power BI reports at once. Therefore, users must download files one by one which is slow, time consuming and inefficient. Thankfully,

In Power BI there’s a popular custom visual called “Filter by list” that lets you filter a Power BI report by any list of values that you paste into it. It can save you a lot of t…

Learn how to create Ordinal Numbers in DAX and M. These numbers describe the position of something, such as 1st, 2nd, 3rd.

I was ready for a nice relaxing evening today, when an email appeared in my inbox “Azure Purview is now Microsoft Purview!” Initially I thought… yeah.. “just another Microso…

I’ve said it before but I’ll say it again: I don’t publish book reviews here on my blog but I’m always happy to promote new Power BI books when they are published in return …

One of the reasons I love using the Excel cube functions to get Power BI data into Excel instead of PivotTables is because they make it much easier to use other native Excel features and functions …

In the first post in this series I showed a simple example of how you can use the FORECAST.ETS function in Excel in combination with the Excel cube functions to do forecasting with Power BI data. I…

In this article, we will discuss how to deal with some common problems when creating reports based on employee attendance sheets. Next, let's take a closer look at the below scenarios. Scenario 1: Clean and extract valid records from attendance sheets Invalid or repeated employee punching behavior ...

Scenario: We usually hear words like words context, filter context when creating measure. Moreover, we can often see it on the DAX Guide website. But what is that? And how can we modify it? What is filter context? The reason why we sometimes cannot get the ideal result when we use a measure with sa...

Use Case - Sometimes there will be a need to extract domain names from given URLs. Hence http://www.microsoft.com should give microsoft. Below are some sample cases and the results expected.   Exclusion - Subdomains are excluded from the scope of this. Hence, https://powerbi.microsoft.com which has...

How do you learn a new skill? How do you go from beginner to intermediate to expert… or at least from knowing very little to knowing enough that other people start to think of you as an exper…