Power BI

Another week, another roundup! Some good updates in this weeks video. Grab a coffee (or tea) and pull up to get the latest about #PowerBI 📊📰 Are Power BI Slicers Still Relevant with the New Filter P…

The latest version of the “release notes” document that details the roadmap for Dynamics 365 and the whole Power Platform – which includes Power BI – has just been released. You can view it online her…

In this blog post, I am sharing a few things I learned while migrating some Power Query queries to dataflows.

In this blog post, I am showing how to export all data from a Power BI file to CSV files or SQL Server tables.

Introduction to reusable components for canvas apps

The new Relationships view (or Modeling view – it seems to have two names) in Power BI Desktop that has been in preview since November 2018 not only makes it easier to work with complex models and set…

There have been lots of announcements about Dataflow online, through videos and articles and news. There are many demos about Dataflow as well. However, still when I talk about it in conferences, one …

Microsoft führt in PowerApps die Möglichkeit ein, eigene ‚Komponenten‘ zu definieren und diese über App-Grenzen hinweg wiederzuverwenden.

Sum, Min, Max, and Average functions in Canvas apps are aggregate functions that can reduce a large amount of data down to a single value. For example, Average could be used to find the average age of a class of students using Average( Students, Age ). These functions can also be used with the Filter function … Continue reading “Delegation of Aggregate functions for CDS”

Some folks had questions about how we built the slicer panel in Power BI from a previous video. In this video, Adam walks you through how to do exactly that in Power BI Desktop.

This is a companion article to my talk, “Working with advanced DAX Models”. It includes some links to documentation, the slide deck, and the PBIX file used in the demos. I am planning t…

<p>This week we have improvements to the Microsoft Flow and PowerApps connectors for Microsoft Planner and Office 365 Outlook, as well as two new connectors: <a href="https://flow.micros…

There’s a new wizard based, easy user interface for column conditional formatting in SharePoint Online!! That means you don’t have to know JSON code in order to do some conditional formatting on your …

A quick hack today. Got this question from someone who needed to be able to update a report and show users that something had changed. This is easy when you...

This is a Preview announcement of new features and UI enhancements in the Data Integrator for Common Data Service for Apps Important Preview features aren’t meant for production use and may have restricted functionality. These features are available before an official release so that customers can get early access and provide feedback. We expect changes … Continue reading “Data Integrator Updates – New features with an intuitive user interface providing a fluent experience”

PowerApps authoring using data is getting easier with improved creation and selection of datasources, fields, and connections. The experience has been updated and search was added to help quickly find the right item. Also more of the data controls can be configured directly in the property pane. This experience is rolling out throughout this week. … Continue reading “Improved datasource and field selection in canvas apps”

Reading Time: 3 minutes Power BI recently previewed a new filter experience with the addition of an enhanced Filter Pane. Rather than rely on the traditional visual level, page level, and report level experience; the filter pane provides enhanced filter cards that are both easily used and can be styled. As seen below where the filter is set to…

Using error tables in Excel and Power BI to handle unsuccessful HTTP Requests.

Happy new year everyone! We are kicking off the new year with an update to Power BI dataflows, focused on the dataflows editor. Power BI dataflows was introduced to public preview in November, and …

Earlier last year, we announced bookmarking to be generally available in Power BI Desktop. Bookmarks are currently used by many report authors to share interesting insights, tell a story, and creat…

Patrick looks at how you can add a link to your Power BI Paginated report and open a Power BI report while passing filters over to explore data.

In this week’s webinar Ted Pattison will be covering how to develop Custom Visuals for Power BI. Power BI has supported the development of custom visuals since its initial release. However, t…

This blog post covers the latest updates for Power BI embedded analytics and Custom Visuals.

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…