Power BI

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...

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 ...

Use object level security and field parameters to apply security to columns and measures in Power BI reports

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.

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…

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.

The Power Query Editor Remove Rows function can help to prepare your data sets to create meaningful reports. Follow this tutorial to learn more.

3 key things to know for your data analysis journey.

say good bye to bookmarks and selection panes

As part of our GA work for the ExecuteQueries REST API, we delivered a new Power Automate action to run queries against Power BI datasets. This action delivers a straightforward low-code/no-code experience to BI users who want to streamline repetitive, mundane tasks and processes. The purpose of this blog post is to help you get started running queries against datasets in Power Automate. It covers exporting data into csv files, building a solution to test datasets, and creating BI-driven cloud flows.

Users can author formatted tables using a modern low code web-based authoring experience in the Power BI service.

Welcome to the May 2022 update. We are thrilled to announce the general availability of Canvas zoom and Data point rectangle select features, Field parameters and Error bars for columns and line combination charts new preview features, new Format pane and managing composite models preview feature updates. There is more to explore, please continue to read on.

Check this simple trick to enhance user experience when using Fields parameter feature in Power BI!

With today’s preview launch of Power BI datamarts, there is yet another data entity to contend with in the Power BI ecosystem. I plan to update this entry as datamarts mature in the months to…

Here is a real-world M Query scenario recently implemented for a client who has signed contracts in PDF format that offers incentives for sales.