Power BI

<p>This has to be one of the smallest features ever shipped. We&#8217;ve modified the behavior of one character, and it is a small character at that. But I think you will agree t…

Many people start with Microsoft Flow or PowerApps every day. In this post I'm answering many questions that I've been asked on a regular basis. What Is Microsoft Flow? This had to be the first questi…

With Power BI apps, you can create collections of dashboards and reports and publish these apps to your whole organization or to specific people or groups. For the second post in our series we’re c…

In Power BI datasets that combine data from multiple data sources in a single M query, privacy levels define a how the data sources are isolated from each other. Restrictive isolation levels block data from being exchanged with other data sources, which can reduce functionality and impact performance but ensures that sensitive data does not … Continue reading “Privacy Levels for Cloud Data Sources”

In this month’s Power BI Digest with Manuel Quintana [Blog | Twitter] and I will again guide you through some of our favorite Power BI updates this month. In our April 2019 edition we highlighted the …

This looks excellent! For the SharePoint list schemas, though - they are .iqy files and upon editng in Notepad seem to go to lists in the microsofteur.sharepoint.com tenant. Is there any way to get at…

Real life example of how I use this: Equipment is tested before being shipped. * The PM uses PowerApps to enter in the equipment details * Engineering uses PowerApps to pull the equipment description …

The new Power BI App Workspace experience GA’d in April of 2019. Adam takes you through what the new Power BI App Workspace is all about and what is coming down the road.

Introduction A request came through for a team to have tasks created in Planner based on a new entry in a SharePoint list. The list has the following inputs, Title for the name of the new project, Cli…

By now, we’ve all seen Microsoft’s rebranding of Power BI, PowerApps, and Flow into the Power Platform, a set of tools for the citizen developer to analyze data, take action from that data, and, ultim…

Here’s yet another entry in the list of useful things I learned from Ehren von Lehe on the Power Query MSDN forum: Table.Buffer() does not buffer nested table, record or list values inside the cells o…

The basic principles of how to combine, stack, consolidate or append data using Power BI / Power Query for Excel for any data source.

This post is a beginning to a series of articles about building analytical capabilities in Azure using data lake, Databricks and Power BI. On the surface, those technologies seem like they were specif…

Patrick takes a quick look at Power BI Report Builder including how to get it. This report builder is optimized for the Power BI service. Patrick calls out a few reasons this is the case. Power BI Pag…

Do you want a customized KPI Card in Power BI? Patrick looks at how you could get a custom KPI Card in a Power BI report without using custom visuals. KPI Card demo files – https://guyinacu.be/kpicard…

I had a requirement where I wanted to extract the data before and after the data as shown below. In order to do this, I created the following Custom Column with the syntax below. I did try and use the…

Leveraging Microsoft’s Power Platform – comprised of Power BI, PowerApps, & Flow – is one way that organizations can use tools to analyze, act, & automate. Each of these tools can be used on its own t…

Watching an interesting video on data science trends by a Google data scientist who recommended this data set as good practice, I recorded a video that documents my process working on it from start to…

This weeks Power BI RoundUp includes updates for Power BI Desktop for April, new features in Power BI Service & Generally available Power BI Services

This article explains the setup instructions to work with the Service tab of Power BI Helper. Download Power BI Helper from here. Power BI Helper is a third party application, and any third party appl…

Level: Intermediate There is a concept in the DAX language called “Syntax Sugar”. Simply put, the developers have created simplified versions of more complex formulas to make it easier…

<p>Embedded canvas apps now provide the ability to perform actions to navigate, refresh and save the host form. With these capabilities makers can now achieve even richer integration between the…

It’s time again to recap all the features and announcements we made in the month of March. Premium Multi-Geo General Availability Users outside your organization can edit and manage content with Az…

In RADACAD we do our best to improve user experience using Power BI every single day, and throughout that experience, we add more and more functions to Power BI Helper. The newest version of Power BI …

April is an exciting month for Power BI Desktop! Our April update has major updates across the entire product. This release adds the ability to define the titles of your visuals and the URLs of you…

Business process flows (BPF) provide a guided way to get work done in the form of stages and steps. Stages tell you where you are in the process, while steps are action items that lead to a desired outcome. Steps in a business process are bound to fields in the Common Data Service (CDS), and until n...

The news about XMLA endpoint connectivity to Power BI datasets is now all around the internet after the public preview announcement of that last week. However, I realized that the XMLA endpoint term is still too technical for many Power BI report developers. Many people come to me asking what exactly is XMLA endpoint, and…