Power BI

This post is an overview of ‘Visual Data Prep’ (Diagram View) which is going into General Availability.

This month, we are continuing our work on the ongoing previews of DirectQuery for PowerBI datasets and Azure Analysis Services, Small Multiples, and the Model View UI. Also, we are making it easier to specify filters in the DAX CALCULATE function. On the Service side, when you click on a dataset in the workspace list view you will be taken to our new dataset details page, which includes information about when the report was last refreshed as well as actions such as creating a new report. Of course, there is much more, so read on!

Last week I was honoured to take part in the latest edition of the Power BI Dev Camp which is run by my colleague Ted Patterson. It was a fun session which I enjoyed. As part of...

The Microsoft Business Applications Launch Event is almost here. Join us on April 6, 2021, from 9–10:30 AM Pacific Time (UTC -7) to discover how new innovations coming to the 2021 wave 1 release will give you the tools you need to transform your business

We are excited to announce General Availability (GA) of support for external tools within the Power BI Desktop authoring experience so that you can leverage a wide range of additional semantic modeling features, DAX query/expression optimization and authoring utilities, and application lifecycle management (ALM) capabilities in Power BI Desktop to boost your productivity as a world-class Power BI solution creator.

I previously wrote a blog post explaining how to rename all columns in a table in one go with Power Query. One of my visitors raised a question in the comments about the possibility to rename all columns from all tables in one go. Interestingly enough, one of my customers had a similar requirement. So … Continue reading Quick Tips: Renaming All Tables’ Columns in One Go in Power Query

Join me tomorrow, Thurs March 18 at 10am PDT / 1pm EDT / 5pm UTC for a webinar hosted by the Power BI team: Improving Trustworthiness of Power BI Content...

How to implement document automation in your business with Microsoft Power Platform. This post will help you implement this a solution as an iterative  journey which could be summarized in 4 phases: building the initial AI model, prototyping, initial rollout in production, and mature production.

Unleash the Power of your solutions. Learn techniques and uses case to use Power Apps, Power BI and Power Automate together!

I have decided to spend some more time on Market Basket Analysis, but before I get into the storytelling part of it, I had to clean up and fix a few things in the model file for the Market Basket A…

[vc_row][vc_column width="1/1"][vc_single_image media="88081" media_width_percent="100"][vc_column_text]Download the following Power BI file as a template to start validating email addresses directly in Power […]

My Top Data & AI Announcements and Session Roundup from Microsoft's Ignite 2021 virtual conference

We are proud to announce great news for DAX Guide! Starting today, every DAX function has its own dedicated video. Moreover, we added new examples that you

Multiple selection checkboxes give a user the ability to pick from one or more options. This feature does not come included in Power Apps. Fortunately we can make our own by combining a single …

Welcome to my first blog post! I've promised to give back to the SQL and Power BI community for almost six years now and have never been quite ready. The community has done so much

Reading Time: 4 minutesFrom a creative standpoint, it’s disheartening if you’re often trying to get users past a Table and Export mentality with Power BI. What otherwise could be a strong BI tool …

The new version of the Power BI Cleaner tool prevents you from deleting DAX expressions that have been used in calculation groups.

As part of the design phase of a Power Apps project, document where and how you'll access existing data you need, and decide where you'll store data you create.

In my company Skill AS we have several years had a challenge called "SkillChallenge" where the main goals have basically been "who run most km during a month" or "who take the longest ride". More and more aspects have been added, like fastest 10K run, km run compared to own goal etc.

A name is important. The right name is important. In this post, I reflect on the choice of names in the Microsoft BI stack. From time to time, a bad name ar

In these articles, regardless of your background or experience level, you'll learn about the steps to convert your ideas into a working solution by using Power Apps.

Just an end user of Power BI? Consuming reports and not authoring at all? Adam walks through how to navigate and use Power BI reports. Jump in and get familiar with reports in Power BI! Reports in Power BI https://docs.microsoft.com/power-bi/consumer/end-user-reports View a report in the Power BI service for business users https://docs.microsoft.com/power-bi/consumer/end-user-report-open

A very common question our customers ask is, how do I implement role based access control in my app. In other words, how do I make certain features or screens of my app available only to the …

Launching the anticipated autoscale add-on preview for Premium gen2 capacity