Power BI

It is very common to have multiple reports for different audiences, while there is also one (group of) user(s) that requires to have an overview over all these different insights. The main challeng…

Certifying content in Power BI should be a very meaningful designation. In this post & video we cover: The two types of endorsements in the Power BI Service What types of content can be endorsed The meaning of certification for data, reports, and apps

Context is the key when you are creating a report! Learn how to provide an insight in the most effective way, by removing distractions from your visuals!

This article describes how to use KEEPFILTERS in DAX iterator functions to preserve arbitrarily shaped filters in context transition. When you apply a filte

On-premises data gateway (standard and personal mode) release for April 2021

Have you ever wanted to use images instead of "regular" text on axis? Or, even within the slicer? Check this simple technique and you're good to go!

How do you build your skills in Power BI? PowerBI.tips brings you key ideas to help you build a learning path and continue to grow.

Reasons why you probably won't be able to use Power BI in DirectQuery mode on top of a REST API

Join Arun Ulagaratchagan on May 4th, 2021 at Microsoft Business Applications Summit!Join the Power BI team and be inspired by exciting new features, see amazing demos, learn about our roadmap, see …

Here are resources to help you learn how to use Paginated reports. You will need a premium capacity or Premium per user license. If you have any extra resources please reach out to me on Twitter …

For a while now, I have been wanting to have the capability in Power Query to select a query by name PROGRAMMATICALLY. Why? Building a SelectQuery Function would allow me to execute one of multiple “Transform” queries depending on a user selection on the Excel sheet. This will help me process log fil

Bring DML to Power BI with Power Automate – Delete Records An exciting addition to Power BI April release is Power Automate Visual. This adds a host of capabilities to Power BI directly without relying on Power Apps. Users can now activate PA flows directly at the click of a button from Power BI p...

A lot of us work with Power Query Editor in Power BI and are familiar with its different capabilities that it provides to a report developer. I was recently approached by one of my colleagues who has started learning Power BI, to check if there is a way to implement CONTAINS functionality on a TEXT ...

Two of my previous posts are related to creating an automated data dictionary - something I believe is essential to inform users about your model and to promote a more optimal use of your model. The …

Do you want to highlight your top or bottom values dynamically in Power BI? Patrick looks at a creative way to accomplish this using WHAT IF parameters. Download Sample

Announcing Charticulator visual preview. Previously to use Charticulator, a user would flip between the web app at charticulator.com and Power BI (PBI). Now, users can create a wide range of custom chart designs right within PBI using our brand-new Microsoft Charticulator custom visual.

Learn about how you can set up dataflow automation using the Power Query Dataflows connector in Power Automate!

Learn how to trigger flows from any Power BI report using the new Power Automate visual for Power BI and the Power BI button clicked trigger.

The purpose of this article is to provide Power BI developers with a deeper understanding of the dependencies when updating data sources in a Power BI dataset through XMLA endpoints. Most importantly, Power BI maintains security-related data source information such as credentials and privacy settings outside the dataset, whereas Azure Analysis Services and SQL Server Analysis Services maintain these settings in the data model.

It’s been a pretty awesome month for folk who want more visualisation opportunities in Power BI - we’ve seen the launch of PureViz Infographic, and last week Microsoft announced the Charticulator …

Hi Power BI Folks! Welcome to our 2nd post here at daxproservices.com.Today, I wanted to share some thoughts about how to keep the house clean when naming the transformation steps of your Power Query …

For a while now I have been looking into how to set up some sort of CI/CD for Power BI. Unfortunately there is not much out there, except if you have the luxury of working with Power BI premium. As…

One of the most common questions coming from customers while using Power BI reports: ‘Can we export this to Excel?’. This to annoyance of most BI developers, as they spent a lot of time…

Over the years I have written a lot about Power BI/Power Query performance but it has always been in the context of loading data direct into datasets, not dataflows. A lot of cool things have been …

In this blog post I show how to create or update a measure in Power BI Desktop and then deploy to Power BI Premium Per User

Empower your end-users to go from insight to action. With the new Power Automate visual, end-users can run an automated flow all within a Power BI report. Furthermore, the executed flow can be data contextual, meaning that the Flow inputs can be dynamic based on the filters set by the end-user.

Welcome to the first Power BI feature summary of the Spring! In this update we have an exciting new preview for the Power Automate visual! Also, the ongoing previews (Small Multiples and DirectQuery for Power BI datasets and Azure Analysis Services) are getting some new features. Next to that, we are presenting huge improvements to the shapes in Power BI Desktop and we are introducing a new, easier, way to share reports. To top it off, enhancements to Sensitivity Labels provide for even better protection of your data. Of course, there is much more, so read on!

Shared via Flipboard

This article analyzes a classic modeling question: is it better to build a model as a regular star schema or as a single table in Power BI? The answer is cl