Power BI

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

Recording from January 2021 Meetup: Data modeling essentials and best practices in Power BI and AS Tabular with Paul Turley

"If 80 percent of our work is data preparation, then ensuring data quality is the important work of a machine learning team." Andrew Ng Data quality is one of the highest challenges in any BI project. ETL developers tend to spend a lot of time creating data preparation processes with complex and expensive pro-code tools…

Describes incremental refresh features in Power BI

Have you ever come across an issue where your Power BI matrix column widths just aren’t the same width and visually just don’t look right? Unfortunately (as of April 21’) there is no easy way to make all column widths equal in the format pane of a matrix visual. However there is a hack to […]

The Power BI Summit

Fluent UI Menu Builder for Power Apps Features Icon Sets InstallationFluent UI Menu Builder for Power AppsCreate Menu Icon Collections for the PP-MainMenu Component included in the solution• Copy Image …

Easily build financial reports with line formatting, conditional formatting, subtotals and more.

Power BI toolkit including Data Lineage, Backups, Change Tracking, Auditing, Usage Analytics and Documentation, to help you keep control of Power BI

We‘re excited to announce object level security (OLS) is now generally available in Power BI Premium and Pro!

I show how using Power BI Premium per user you can do granular deployment of a new column without having to update the entire dataset.

Rolling averages (a.k.a. moving averages or running averages) over time are useful to smoothen chart lines and to make trends more evident. This article sho

Deployment pipelines helps enterprise BI teams build an efficient and reusable release process by maintaining development, test, and production environments.BI teams adopting deployment pipelines, …

Sharing reports in Power BI will be as easy and familiar as sharing in Office. At the end of this month, we’ll be introducing a new sharing capability in Power BI that will allow reports to be shared with people within the organization through shareable links.