Power BI

Welcome to the November 2021 update. The team has been hard at work delivering mighty features before the year ends and we are thrilled to release new format pane preview feature, page and bookmark navigators, new text box formatting options, pie, and donut chart rotation. There is more to explore, please continue to read on.

We’re excited to announce enhancements to the export to Excel experience. Read this blog to learn how these changes help more Excel users use data from Power BI to make decisions.

We’ve heard your feedback and would like to introduce you to the redesigned format pane! In this blog post you’ll find the biggest changes we’ve made to improve the usability and consistency across visuals and non-visual elements.

I was shocked, suddenly important reports were missing from my workspace in Power BI service. But thanks to the help of Mellisa Coates, I was able to make

Download the cheatsheet that will help you fine tune your Power BI reports!

A while back, I was working on a project involving getting data from Excel files. The Excel files contain the data in sheets and tables. Getting the data from the tables is easy. However, the data in the sheets have some commentaries on top of the sheet, then the column names and then the data … Continue reading Combining X Number of Rows in Power Query for Power BI, Excel and Power Query Online

Here is a fun way to use Q&A functionality to build a data dictionary in Power BI and add GIF animation to the report page background.

While you're validating your idea, there is no need to spend a fortune commissioning a decent-looking logo. We have created a library of free logos which you can use as placeholders for your projects.

I first wrote on this topic way back in March 2019. I love Power BI, and it is one of the most affordable BI products on the market for most companies. If you are a small company of 10 or 20 people, it is dirt cheap at $10 per user [...]Read More »

The Microsoft Ignite Book of News is your guide to key news items that we are announcing at Microsoft Ignite.

I know that I personally have been interested in what makes up a PBIX file and in this blog post below I will explain from my understanding what are the different parts that make up the PBIX file. It is rather interesting in that it is actually made up of a few different aspects. How to view the contents of...

One of the many benefits of Power BI is the possibility to create your own theme file, which defines many design properties of a report…

Optimize your images and convert them to base64 online. Drag & Drop your files, copy to clipboard with a click and use the result in HTML and CSS.

Summary of planned features for Power BI.

"It's M365 Below in Chicago!", an On The Spot Network event, needs you to share your expertise with other professionals that work with Microsoft 365 and Power Platform across the world!The next M365 …

In this blog post I detail how to to configure and backup Power BI Premium per user or Power BI Premium databases.

I’m happy to announce that the Power BI App for Microsoft Teams is Generally Available. Learn about the enhancements to the app, how we’re making it easier to deploy it, and how easy it is to get started using data to make better decisions and take better actions.

We’re excited to announce enhancements to the Power BI experiences for Excel users. Read this blog to learn how these changes help more Excel users use data from Power BI to make decisions.

Hello everyone, and welcome to Ignite 2021! Our team has been working nonstop since we last met in March, and we’re excited to announce how we’re bringing more innovation to you and your customers.

We’re excited to announce new capabilities and improvements for Power BI goals that make it easier than ever to integrate goals into all of your business processes. Learn about the new goals visual, Power Automate integration, goal level permissions, and other experience enhancements.

Report Analyzer now has a recommendations engine for report best practices!

List of the most common univariate statistics DAX functions available in Power BI, as of now most of them are built-in functions but the more complex ones still require writing some Dax code. The list will be kept up to date please let me know if you thing a function is missing. eyJrIjoiNzFjZDkwNTkt...

If you’re working in Power BI Desktop you may sometimes find that your visuals error with the message “Couldn’t load the data for this visual. The operation was cancelled because …

Complete Guide to Lists in Power Query. Learn how to Make Use of the Most Powerful Power Query Functions (And Master Them).

In one of the projects, I was working on, I received feedback saying it is hard to understand how many items they have selected in a slicer, and it is…

This post shows how to overcome a limitation in conditional formatting in matrix, where you can't define a dynamic color gradient for values and totals.