Power BI

I've been asked from one of my friends who were trying to create a random dataset for his presentation. There is a great and quick way that you can create a random list of numbers in Power BI using Power Query. In this short blog post, I'll explain how to create this random list. You…

Learn how to use DAX to create a custom TEXT column sort order. This tutorial explains a simple solution to ordering items. Click here to learn more.

Walking through how to refresh datasets and create near real time reports in Power BI with the PowerApps Custom Visual. Starting from Power BI we need a report that is based on Direct Query. To sa…

Related demo can be found here: The second walk through below: PowerApps is the perfect complement to Power BI in that it makes it very easy to update or add data to the underlying datasets th…

PowerApps with Refresh Lab eyJrIjoiMjllMmY0YjktN2Y4OC00ZjRjLTlmNzktMmNjMWU0YTRjMjQ3IiwidCI6ImZkMTI5OGJlLWMwOWYtNDM0OS05NmU4LWJkMDk3MjEwZTI3NCIsImMiOjF9

We’re happy to announce our September 2019 update of Power BI Report Server! This release is packed with tons of reporting features, including visual level filters for slicers, Icon sets, grouping for visuals, new default themes, and more! In this release, you will also see the new updated design, the new filtering experience, and more conditional formatting options. Read on to learn more about the new features and many other capabilities in this release.

Adam looks at how you can get your gateway working with Power BI dataflows, even if you aren’t an admin of the gateway. There is one thing that most people overlook. We show you what it is!

I have previously written how to create a ragged hierarchy, which can be used for organization hierarchy or chart of accounts or similar scenarios. A ragged hierarchy is a hierarchy with un-even number of levels. In a parent-child scenario of organization hierarchy, for example, the CEO is the highest level of the organization, so won't…

Use Groups in Power BI to change the style of your report. Click here to read about how to create a group of visual and add style for your report.

We often focus on deep analysis and insights generated by machine learning when we talk about Power BI these days because it’s super cool and very fancy. But I think it’s important to r…

Patrick walks you through how to use custom format strings in Power BI Desktop. From dates and time to numbers, he calls out some things to look out for. Custom Format String Documentation: https://do…

Do you want to add drop shadows to elements in your PowerApps without using images? PowerApps does not provide an OOB property to set shadows for elements or controls but you can use the HTML text …

Learn how to use a custom color palette, and apply it to an entire report in Power BI Desktop

The reaction to this recent post on lineage and Power BI dataflows highlighted how important lineage is for Power BI[1]. Although (as this post shows) there are lineage user experiences in place fo…

The Power BI REST API provides lots of data for Power BI admins. Easily import and monitor this data in Power BI with a Power BI REST API custom connector:

We’re thrilled to introduce template apps update capability! From now on, after downloading and connecting a template app from AppSource every Power BI Pro or Premium user can update the app while preserving the connection configuration.

The seventh and last blog in the storytelling series. Took a while before writing it and finishing this blog series. Up front I promised to publish a blog every week, but that simply didn’t w…

Use PowerApps checker to see a list of potential issues in your Canvas apps.

If you've worked with Power Query in Power BI, you've seen Column Quality and Distribution features already. Today, I've finally received it in the Insider build of Excel!

This blog post shows how you can accurately replicate the Excel TRIMMEAN function in DAX, accounting for duplicate values at tails.

You should master tables in M/ Power Query, in order to become an M ninja. This post shows you all the basic concepts behind this value type.

See how you can give the power to the consumers over the report design with the recent changes in Power BI.

This is What I Want (What I Really Really Want): Zeroes to Rank Poorly. Divide by Zero Errors to Display “N/A.” And “N/A” to NOT participate in my ranking. RANKX: the Mother of Many Blog Posts Ya know, we could probably write articles about RANKX for an entire year. There are just SO many subtleties to it, and

Conozca la experiencia del usuario para 'Obtener datos' que puede obtener de Power BI / Power Query con sus conectores, parámetros y funciones.

A table, matrix or a grid is the most basic form of a data visualization, and at times it can be just the right data visualization to use. In this post I'll go over how you can see the most effective use of these types of data visualizations in our daily lives.

In this post I will look at the different options we have for summarising the data using grouping and pivoting with Power Query.

In my last post I showed lots of examples of how Power BI’s new custom format string feature can be used to format numbers. This post, looking at dates and times, will be a bit different for two re…