Power BI

Do your Power BI users understand your report? Chances are, at least not all of it. Help them out with an information panel to help describe the report and understand all of the capabilities. Adam …

Object-Level security exists for a while in some Microsoft's products. But, this is a brand new feature in Power BI! Still in preview, so let's put it in the spotlight and check all its Pros and Cons

Sometimes you want to reduce data in Power BI Desktop so it’s easier to work with. Then work with all the data in the Power BI Service. Patrick shows you 3 ways that can help do this without using Incremental Refresh or needing Power BI Premium!

Customise, adjust and download free vector icons. Ikonate is an adaptable set of optimised, accessible SVG icons that use can easily use in both development and design apps such as Sketch and Photoshop. Ready to use as images, inline SVGs or SVG sprites.

IconPark, park your icon. Made by ByteDance

Feather is a collection of simply beautiful open source icons. Each icon is designed on a 24x24 grid with an emphasis on simplicity, consistency and readability.

Remix Icon is a set of open source neutral style system symbols elaborately crafted for designers and developers. All of the icons are free to use for both personal and commercial.

The simple and easy to build and design reports in Microsoft Power BI.

In my ETL workflow, there are always larger text/CSV files, error files to view or one-time files I need to modify. The biggest feature I need is to page through large files as some will not fit into memory. I found a great CSV editor that I think will fit your data workflow also.

This blog post demonstrates how to feature a certified app in Power BI Home and in a Users Apps to be easily found.

Make sure you get notified when the Microsoft Power Platform user groups go live for public preview.

As you may have noticed, life is complicated and keeps getting in the way of my plans to be a more active blogger and YouTuber[1]. I haven’t released a new dataflows video of my own in far to…

Today’s post builds on top of Power BI Admin Scripts Part I by describing five additional PowerShell scripts that Power BI service administrators can utilize to address relatively common scen…

On-premises data gateway (standard and personal mode) release for March 2021

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

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 […]

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

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.