Power BI

Continuing the series on “translating” Tableau to Power BI, let’s consider Tableau’s Viz in Tooltip. The versatile Viz in Tooltip allows authors to embed content from one or…

Have you ever needed to get data out to an internal customer quickly to meet an urgent business need, in an easy to access, updateable format? Of course! There are lots of ways to do this, and I’ve tr…

A frequent pattern implemented in PowerApps is to have some form of debug buttons or panels that are only displayed when the Makers of the…

This article shows how to improve line charts with a date-based axis in Power BI using DAX and correct choices in data modeling and visualization properties

Recently a customer asked if PowerApps can support role based security controlled by SharePoint Security Groups. For example, can you make an Admin screen that is visible only to users who belong to a…

CDS for Apps VS Power Query – is there a difference? If so, what is that difference? Are they mutually exclusive or complement each other?

In the first part of this series we walked through creating multi-step form indicators in PowerApps. This post will help build a simple secondary navigation scheme using breadcrumbs to in…

According to the Endowed Progress Effect (which is a phenomenon integrated into designing any UX process based on how the human brain makes decisions) we’re more likely to complete an action if the…

I have a dropdown list and i want to set that the default value when the formmode is new to a character like "-" and when the formmode is somethings else it will go with the ThisItem.VariableName So if the dropdown list is named country then the function would have been. If(SharePointForm1.Mode...

I created a purchase request app with two galleries connected to their own SharePoint List, "RequestList" and "ItemsList." The user clicks on the "RequestGallery" and it loads the "ItemsGallery." The user can then add/edit/delete items associated to their purchase request. All rows in the ItemsList...

Since the Eagles game doesn’t start until later, thought I’d put this together for folks. As many of you know, earlier this month we announced a preview of Paginated Reports in Power BI. While fol…

I have seen a lot of questions in the Power BI Community asking how to connect to a SQL Server Read-Only or Secondary replica, and whilst this is not currently available in the Sql.Database M conne…

We are happy to announce that we have just released the November update for the On-premises data gateway (version 3000.0.155.1) &…

Unlock all of the power of Power Query in Power BI dataflows

Warehousing SharePoint data has been a need that has been with us for a long time. Power BI dataflows finally provide a reliable way to solve this need.

Sometimes, the new connectors are added to Microsoft Flow that open up a lot of options. One of those connectors was added to Flow last night. The Encodian connector makes it possible to do a lot w…

Today marks the 20th birthday of Analysis Services: it was released (as OLAP Services) on November 16th 1998. There’s a celebratory blog post and video over on the Power BI blog here: I’m one of th…

One of the most common issues faced when calling web services in M is that the the easiest way of doing so – creating a function that calls the web service, then calling the function once per row in a…

The big news in the world of Excel right now is the introduction of dynamic arrays. They’re only available in the Office 365 click-to-run version of Excel and, at the time of writing, only available t…

This app simulates the motion of throwing a ball based on concrete physics. Time development of ball is basically given by the motion of projectile with gravity and air resistance (See attached photo), also I have implemented effects of bounce and reflection.

Be Insights Driven, not Data Driven, and definitely not Tool Driven. Tableau vs Power BI vs Qlik

Happy 20th birthday Analysis Services!

At PASS Summit, I presented a session called “Do Your Data Visualizations Need a Makeover?”. In my session I explained how we often set ourselves up for failure when conducting explanat…

The new modeling view in Power BI Desktop is designed to work with enterprise datasets that grow in complexity