Power BI

New amazing #PowerBI feature 😍 Field parameters 😍 It is now possible to compose a parameter from different columns, useful to create a dynamic axis in a visualization. #PowerBI has released the fields parameter, we can now build a slicer to choose any dimension and also measures we want to visualize

Context transition is one of the most obscure topics for DAX newbies. Learn how it works, its effects, and how to leverage it rather than be scared of it.

Learn how you can set the same color for the same data value across multiple visuals and pages in a Power BI report using examples.

I show you how to create a Power BI report with a dashboard and a Power BI Alert when there are new additions to the known issues.

With the new Power Field Parameters I explain with images how it works and what the current limitations are.

SQL Server 2022 Analysis Services will support composite models and it is now ready for you to try out with the CTP2 that has just launched. After you install this CTP for SQL Server 2022 on a server, tabular models are hosted on that server can now be used to create a composite model with.

A couple of days ago, Thoughtspot released a new tier tailored for Small and medium enterprise, see the pricing here, The big surprise, unlimited users is a standard offering even for the entry lev…

A guide to making visualizations that accurately reflect the data, tell a story, and look professional.

It’s frustrating that in Power BI re-naming measures or moving them to another table will break any visuals using them in reports . Likewise, Power BI does not have a feature to hot-swap measures in visuals, to retain formatting or save time. Here I will show you an easy way to replace multiple me

In this post, I write about the similarities between scientific research & business intelligence. This article was originally written in 2019; I re-published it to support an article I’m working on about Power BI in Academic Research.

I believe that Power BI - if successfully adopted & supported in a scientific research department - has the potential to deliver tremendous value. In this article, I try to explain how, and why this benefits researchers & society as a whole.

To group some data in the report, it is very common to create a custom column or a calculated column based on specific conditions, and then put this column in a slicer to filter visuals. This would generate more data in the model and the group result is fixed. If the data used in the conditions is f...

We are excited to launch the public preview of user defined functions, a new feature for mapping data flows for Azure Synapse Analytics and Azure Data Factory. User defined functions allow users to define reusable functions that can be used across many mapping data flows. If you ever find yourself d...

Get OneNote for free! Works on Windows, macOS, iOS, Android, and in your favorite browser.

Welcome to Updates, an out-of-the-box app that allows you to create, submit, and review updates. Read more to learn how to get started.

Overview of datamarts and how to use them

When building an enterprise reporting solution with Power BI, a question that always comes up is how to handle translations. Large enterprises operate in various countries where people also speak different languages. So a report should be available in all frequently used languages. Ideally, you just create a report once and then a user can…

This is a new May 2022 desktop feature, and it apparently goes beyond the DAX with a number properties that need to be set in order for Tabular to recognize it. A full thread of the details can be ...

When creating an #OLS role to limit access to certain columns, measures or tables for certain users, the visual containing the restricted fields will be interrupted. This is why we need to create multiple report versions for different security roles.

Microsoft customer stories. See how Microsoft tools help companies run their business.

We’re thrilled to be shipping Power BI Data storytelling that lets you add Power BI reports and bookmarks to your slides and enjoy the delightful interactive experience of Power BI inside your presentations. With data storytelling, data will always be up to date in your slides, whether you’re building a presentation or presenting it live to others.

Today, we are excited to announce General Availability (GA) of automatic aggregations, along with several important improvements. By using automatic aggregations in Power BI Premium, you can unlock cloud-scale data volumes for interactive analysis. Automatic aggregations import data into the dataset only at the aggregated level while leaving the detail data at the source to minimize data duplication. In this way, most BI queries can benefit from Power BI’s blazing fast query performance in import mode, while occasional detail queries can still work transparently against the data source in DirectQuery mode.

Like many, I was very excited to see the new Field Parameters feature that shipped in preview in the latest May 2022 release. It enables you to do some things that used to be complex in a really ea…

Field parameters allow the report designer to switch the content of a visual with ease. This feature allows the report consumers to interact with data without needing to create their reports

Azure Synapse Analytics May 2022 Update Welcome to the May 2022 update for Azure Synapse Analytics! This month, you’ll find sections on the new Azure Synapse Influencer program, Synapse Data Explorer live query in Excel, a Data Warehouse Migration guide for Dedicated SQL Pools in Azure Synapse, how ...

We are excited to announce general availability for metrics in Power BI (formerly called goals) along with new features to deliver scorecarding scenarios even more effectively within Power BI. Additionally, we’re pleased to share plans for how Power BI will work with the new Viva Goals offering from Microsoft to empower organizations more effectively meet their goals with OKR experiences connected to Power BI data, delivered by Viva Goals.

Microsoft Build represents the ultimate developer event. A hundred thousand developers from across the world gather for three days with their peers to learn, engage, and collaborate on the latest innovations and tools from Microsoft.

Announcing public preview of datamart in Power BI, a new Power BI Premium self-service capability that enables users to uncover actionable insights through their own independent and dependent data sets. For the first time ever, we are empowering everyone with the right-sized ability to build datamarts that can be succinctly and centrally governed and managed for workloads up to a terabyte. This new out-of-the-box Power BI capability effortlessly brings turnkey data warehousing to millions of Power BI users, alleviates demands on IT and accelerates time to insights from months to minutes.

Earlier this week a new feature was released in preview. Take any image of a form and turn it into an app. All using the standard out of the box Power Apps