Power BI

It is only a week ago when I posted the icon library for diagrams.net, also known as draw.io, wrote a blog about it and shared with all of you. Now it is already time to give it the first update! A…

It’s been a while that I am working with OData data source in Power BI. One challenge that I almost always do not have a good understanding of the underlying data model. It can be really hard and time consuming if there is no one in the business that understands the underlying data model. I … Continue reading Quick Tips: OData Feed Analyser Custom Function in Power Query

[Availability update | July 28th, 2020 | Microsoft Lists began roll out to Targeted Release (TR) customers in Microsoft 365, planned TR completion by end of August 2020 where we'll then begin broader production roll out - more availability insight in the FAQs section below] At Build 2020, we intro...

GitHub actions for Power Platform available in preview

Today’s announcement by Arun around the introduction of a Premium per user license option has generated a lot of interest and excitement in the Power BI community. It has also generated a lot of questions, so we’ve put together this blog post to answer some of the most common ones we’ve seen.

Starting this month, we have merged the Power BI Desktop, Service and Mobile blogs so there is one overview of everything that is new in this month. For now, let us get started because we have exciting updates this month! Amongst others, in the analytics area, we introduce a preview of the Smart narratives visual which helps you quickly summarize visuals and reports by providing relevant out-of-the-box insights which is customizable. On the reporting side, several things are added, including the introduction of controls for the z-order of visuals, and searching for a workspace during publis...

This is the year that low-code cloud transformation goes mainstream . With that I’ll also share my top five reflections on Ignite from a cloud strategy perspective. Joe Griffin has got a great top five at a more detailed feature-by-feature level on his CRM Chap blog , and I also recommend you

The Power BI administrator role is a high-privilege role which should be carefully managed. As with many aspects of administration and governance, this involves having a balance between people being able to get things done and risk of when too many people having elevated permissions. This post &

Working with a Golden Dataset in Power BI is considered as a best practice. But how to proceed if you decide to split up dataset and reports later?

The ‘new look’ of the Power BI service is evolving again based on your feedback during public preview…

Recently, Dave Ruijter posted a blog about a library containing all the Azure Icons. He shared all icons in his GitHub repository which allows you to directly connect it to the tool Diagrams.net (p…

Recently, I have presented a webinar about Driving a data culture in your organization. During this webinar, I presented what challenges you might face, what mistakes are made often and what you ca…

Using Power Query I show you how to embed your username and password authentication in the headers section of an API call.

Today we’re excited to announce a broad set of new ALM capabilities for importing solutions. In addition to these modern new interfaces, now you can establish connections as well as set values for environment variables.  We’re also excited to announce that environment variables are now generally available. Together, these features address some of the largest application lifecycle management problems facing the Power Platform.

Contribute to DavisZHANG-BlogOnly/dax-beautifier development by creating an account on GitHub.

This article explains why in many cases, MAX should be used instead of LASTDATE to search for the last date in a time period using DAX. Many DAX newbies use

Until recently, I had not spent a lot of time building Power BI Reporting solutions that have SharePoint Online as a data source (This article refers to SharePoint Online specifically, but I am sure the experience is the same with on premise SharePoint). Over the last month or so I [...]Read More »

In the last two posts, I have explained what is Q&A visual and how we can define an adjective for each column. In this post, I will explain how to define a synonym for a column so if the business users use another word with the same meaning, still they able to use Q&A visual.…

Regarding using Charticulator for creating custom visuals, I come across one of the visuals in the Charticulator gallery and I decided to follow it up to see how it created. So I manage to create a dataset that has ranking, name and amount. In this example, I am using Carbon dioxide emission data for each…

When looking to create dynamic column headers in tables and matrix in Power BI. This is one way where it will always change with your dates.

When looking to automate the storage of your datasets for the past 2 years, I show how you can do this using Power Query in Power BI

Previously, AutoML models could only be applied to entities in the same dataflow. With this new capability, users don’t need to be an owner of the dataflow that has the model.  They can use models created by others in the same workspace.

We’re pleased to announce two new actions are available for the Power BI connector in Power Automate. Now, you may easily leverage the Power BI export API for either Power BI reports or paginated reports in your workflows in Power Automate.