Power BI

I am involved with a Power BI development in the past few days. I got some data exported from various systems in different formats, including Excel, CSV and OData. The CSV files are data export dumps from an ERP system. Working with ERP systems can be very time consuming, especially when you don’t have access … Continue reading A Power Query Custom Function to Rename all Columns at Once in a Table

We have added lots of new capabilities to Power Query Online & Dataflows. This blog post provides a recap walkthrough of these new capabilities.

We hare happy to share details about availability of enhanced Power BI premium using the next generation technology from Power BI

We are almost ready to launch the public preview of the new Power BI Premium per user SKU in early to mid-November.  We are excited to give users access to these capabilities as soon as possible, while at the same time ensuring that we are prioritizing the users/tenants that are most interested in previewing these capabilities. 

The date you have long waited for has finally arrived!  The public preview of Power BI Premium per user has been enabled in all public tenants that requested priority access, and will be rolling out to all tenants worldwide throughout the month of November.  Now, Power BI users have access to all the Power BI Premium capabilities, on a per user basis, for the entire trial period for free. 

 Anomaly detection helps you enhance your line charts by automatically detecting anomalies in your time series data. It also provides explanations for the anomalies to help with root cause analysis.  With just a couple of clicks, you can easily find insights without slicing and dicing the data.

This post is an overview of ‘Visual Data Prep’ (Diagram View) which is going into Public Preview.

Calculating and visualizing semi- and non-additive measures like distinct count in Power BI is usually not a big deal. However, things can become challenging if your data volume grows and exceeds the …

Level: Intermediate. One of the commercial services I offer is to complete a health check of Power BI deployments. I look at everything including the data model, the DAX, the queries, the distribution approach, and other things to help you polish your work. I thought I would share with you [...]

The default way to retrieve files from a SharePoint folder is slow and getting a single file cumbersome. See functions that improve import from Sharepoint.

Originally posted on PowerBI.tips: https://powerbi.tips/2020/01/power-bi-field-finder/. If you haven’t yet, be sure to check out PowerBI.tips for all kinds of wonderful Power BI content!Download (and …

We are excited to announce the preview of the horizontal container and vertical container layout controls that help automatically reflow and resize controls within them to enable easy, no expression responsive layouts in canvas apps. These are available in mainline and Teams authoring experiences.

Our anomaly detection algorithm detects that there is an anomaly this month: Anomaly Detection is in preview! Also, we are announcing a preview of the new Field List and the Model View. We are adding a fan-favorite: the Visual Zoom Slider! In the Service, endorsements for datasets and dataflows are extended to reports and apps, enabling business users to be confident they are making decisions based on the right data. Read on to explore and discover more in this month’s update.

DAX Power BI Visual Studio Code External Tool

All the improvements of the ‘new look’, from navigation updates to the simplified action bar for reports and dashboards, begins rolling out next week and will be generally available to all tenants and users by early November. Thank you for your feedback during public preview as we made incremental updates to modernize and simplify the Power BI service.

This post will show you how to do Bulk Renaming of Duplicated Power Apps Controls and save hours of your time for each screen duplicated.

We’re proud to announce the preview of new modern Fluent UI controls for Power Apps. These controls enable makers to create apps which more closely align with modern Microsoft patterns and styles.

Part 1 of a series of tips and tricks for Power Apps forms. Get some additional tips and tricks from Microsoft MVP Sancho Harker.

Hello everyone, welcome to the second in this series of articles where I provide you with many of the Tips and Tricks I commonly use when utilising Power Apps Forms.Tip #3 – Don’t use the Title …

Power BI CoE is an important concept if it is understood that Power BI implementation does not end when the platform is open and available to your organisation.Implementation starts at this …

Since October 2019, it is possible to share a Power App with an external user, but many people still aren’t aware of that or don’t know how to do that. In this blogpost, I will explain you how to do this. External user First of all, let’s define an external user. This is a user […]

Drill through from cards is a common requirement in Power BI reports. In this blog post, I'm showing two ways to configure it.

Moving important business data into a data model for analytic reporting can often be a two-edge sword. Data retrieval is fast and can support all kinds of analytic trending and comparisons. But, da…

I’m always looking for more productive ways to work with Power BI and associated tools. As I covered in my article last week, development of Power BI reports using SharePoint for your file storage can be so slow that it is impractical. In this article I discuss the various options [...]Read More »

Waterfall charts provide a great way for users to visualise how pieces of an overall plan (or results) are combined to contribute to an outcome. For example, you could use a waterfall chart to show how sales have increased by year and category as illustrated below using the standard waterfall [...]Read More »

The last post and video in this series looked at the broad topic of training. This post looks at as specific aspect of this topic: letting people know what is possible, and sparking their imaginati…

Last week’s post on migrating to Power BI was intended to be a stand-alone post, but this excellent comment from Matthew Choo via LinkedIn made me realize I had more to say. I could not agree…

In an ideal world, everyone knows where to find the resources and tools they need to be successful. We don’t live in that world. I’m not even sure we can see that world from here. But i…

Power BI lets business users solve more and more problems without requiring deep BI and data expertise. This is what self-service business intelligence is all about, as we saw when we looked at a b…

At Microsoft Ignite, there were two really exciting announcements when it comes to enterprise features for Power BI. Both directly took my attention, as well as for many others. Obviously, the firs…