Power BI

Useful tips and tricks for Power Apps.

I have been doing some work with Power BI Composite models, and what I have found is that often the DirectQuery table can be changed to an Imported table. I personally feel that this blog post will…

A weekend challenge I hope you are enjoying your second weekend of 2019. I was helping a friend recently figuring out the following data challenge: You have a table of Backlog items with three levels of hierarchies (Scenario, Feature and Backlog Item). In each row, the source data includes the unique ID of the lowest …

Want to run Power BI on a mac? We look at what your options are to get Power BI Desktop running on your mac. You have a few choices. Ideas: Power BI Designer for Mac Apple Boot Camp Parallels Turbo.net

(2019-Jan-14) Dynamic maps with dynamic visualization usually attract my attention, especially when I look at the satellite images of vari...

A guide on how to create a modal dialog that can be used as a confirmation step, used for adding additional details or even display more details in a current screen. Background Two SharePoint lists…

The current version of DAX has a limitation for names you can provide to variables in a DAX expression: a variable name cannot be the name of a table in the

Using Power Query to write out data is usually a very bad idea. But I found an exeption where it made a lot of sense to me: Writing data to GitHub to feed..

Whitelisting Azure IP addresses for Key Vault (@UOldfield) The Necessary Extras That Aren’t Shown in Your Azure BI Architecture Diagram (@mmarie) Finding the Flow: A Beginner’s Guide to Microsoft Flow (@PowerPivotPro) Use more variables in DAX to simplify your life (@kjonge) Easily embed secure Power BI reports in your internal portals or websites BONUS ITEMS: […]

I have already blogged in great detail many times about Power BI/Power Query data privacy settings (see this series for example) but there’s always something new to learn. Recently I was asked a qu…

<p> Microsoft PowerApps activity events are made discoverable within the Office 365 Security &amp; Compliance Center. </p>

Microsoft rolled out a new embedding feature for Power BI content. Next to the already known features as Embed in SharePoint Online, Publish to Web and Power BI Embedded, there is a new feature ava…

Last Tuesday I discovered an interesting option in the app settings of a PowerApp in my preview environment. I was able to enable PowerApps components in my app! This makes me really happy 😍 I was lo…

Introduction This post is in three parts. The first part is to create the dataset in Power BI, the second part is to add actions to the flow and the final part is to create a simple report in Power BI…

Every day I learn something new about PowerApps. Yesterday it was Components; today I am learning everything there is about the PowerApps Notification connector in Flow. PowerApps Notification connector What is the PowerApps Notification connector? As the name says, it offers you a way to send push notifications to users

<p>In our effort to comply with GDPR, we have released PowerShell script functions (cmdlets) that make it easier for admins to manage data and resources on their instance of PowerApps, Flow, and…

In just a few weeks (Jan 21-22) I will be presenting on two topics at the Power BI World Tour in Tampa. There’s a great line up of speakers including those on Microsoft product team, MVPs, User Group …

A PowerApps Naming Convention Proposal What’s in a name? Well, if you take the amount of effort that some brands go to in order to make themselves immediately recognisable, it would appear that names …

Dynamics 365 and the Power Platform are both deeply coupled with the Common Data Service (CDS) and are held in containers called environments. There are different types of PowerApps environments and e…

Today I ran across a pretty straightforward DAX challenge that is made so much simpler thanks to variables. So I decided to share it. Remember folks use variables for each...

Use Microsoft Flow in conjuction with Quick Parts in a Word document.

Learn how to upload a file to SharePoint online document library from PowerApps form using Microsoft flow.powerapps upload file to sharepoint document library.

This blog post I will demonstrate how to change a DateTime column data type to Date dynamically. You might be wondering what I mean by dynamic, this means that I will not specify any actual column …

When attempting to connect Power BI to a JSON file on SharePoint, and used the Copy link URL of the JSON file. Received the following: The JSON file points to an URL API. There are no issues when connecting to the JSON file when it is located on the desktop, nor when connecting to the URL API...

The pages in the Flow portal, including the flow list, now support filtering to find items in the grid. You can now create a page approval flow for SharePoint libraries to add a Flow-driven review process for all new and updated pages. This week there is also two new connectors: Acumatica and Plumsail HelpDesk.

Patrick finishes his look at Paginated Reports in Power BI. He shows you how to create sparklines, indicators and conditional formatting within the Paginated Report using Report Builder.

Power BI already has an easy way to embed Power BI reports into public websites with Publish to web and to secure SharePoint Online pages with the Power BI web part. However, embedding content into…

Intro Buttons, Excel, Approvals and notification in one MS Flow. Tracking a starting and end point into Excel, by triggering a button. This is a flow that I will talk about today! The solution will have two Flow's that could be triggered by a button. The values will be added to an excel file that is...

I don't hear this question as often as I used to[1], but I still hear it: What's the difference between dataflows in Power BI and Data Flows in Azure Data Factory? I've already written extensively on …