Power BI

The is a follow-on post to the Basics of Python in Power BI post. The idea behind the first post was to illustrate the most basic of Python integration in Power BI by keeping the Python code to a bare…

This is part 4 of the Python integration in Power BI series. We are going to explore sourcing data from SQL Server (including Azure SQL DB). If you have been following the series, you would be fami…

I’m managing an Agile team project using Microsoft Teams – the new project management platform integrated with Office 365. Teams is a simple and useful project management tool but it’s new and lig…

Have you ever wanted to run an example of a function to refresh your memory on the value returned, or the function’s behavior and/or input parameters? Are you interested in extending your kno…

Welcome to my link-collection about everything related to the Power Platform. If you know an URL worth adding – please send it to me! I will update the links… Product Group Blogs toolna…

I am always interested in what happens under the covers when I open Power BI Desktop. So I did a little digging and I got the inspiration from Macro Russo when he did his Webinar as well as present…

In this video, Patrick talks about Power BI Desktop and role-playing dimensions. Can you even do this in Power BI Desktop? Patrick shows you why one particular way is not recommended as it will cause trouble. And then show you how you can use DAX within Power BI Desktop to take this to the next […]

I don’t like writing reviews of books or products here on my blog for a couple of reasons, the main one being that I don’t usually have the time to read/test/understand something properly so I can wri…

Using Grids to Improve Visualization Placement (@PowerBITips) What runs under the cover when I open Power BI Desktop (@GilbertQue) How Query Folding Works (@ExceleratorBI) Visualizing Network Data in …

I have recently had some discussions with regards on how to enable the default selection of a slicer which will always keep the slicer selection on the current month. As is currently stands there i…

Microsoft Cognitive services are collections of API and services that help developers to create more smart applications and reports. By using Cognitive services, developers able to add intelligence fe…

We are very excited to announce that as part of our September update, we have a preview of aggregations, which allows you to seamlessly store only summarized values in memory without having to load your entire dataset into Power BI, greatly improving the performance of your reports. This month also includes a preview of a PDF file connector, which is the most requested connector on UserVoice; and one of our biggest updates to our advanced query editor in quite a while, M intellisense.

Welcome to another week of my Power BI Round Up. And as expected there is another massive Power BI Desktop Update. Power BI – September Update for Power BI Desktop As always I am going to over the …

I just finished my session at SQLGLA, with a full room there were more people than I could’ve hoped for. Looking at the other speakers, I’m not even sure if i would’ve attended my…

A requirement that we face very often in our projects is to be able to easily re-use multiple measures particularly when dealing with similar data models on a standard data source like for example clo…

Hello again everyone! Christopher Scott, Premier Field Engineer here. Recently I have been developing a lot of data insight reports for various datasets and customers and thought I would wrap them up …

Make a difference in Power BI as new features are designed by joining our Power BI research panel. You will get a chance to improve Power BI by giving your feedback before features ship. Not to…

James Phillips, Microsoft corporate vice president and leader of Microsoft’s Business Applications Group will be speaking on Wednesday, October 17 at the Phoenix Convention Center for User Group Summit.

Why I changed my mind about #PowerApps and became a fan… and why you should, too (@jenstirrup) Optimizing DAX with cardinality estimation (@marcorus) Announcing Dashboard Comments in Power BI: Your new hub to discuss data and collaborate with others Power BI Service and Mobile July & August Feature Summary Power BI Desktop September 2018 Feature […]

In this video, Patrick takes a look at Power BI Many to Many relationships. This was part of the July 2018 Power BI Desktop release and can enable some awesome capabilities. Patrick looks at why you m…

At the Power BI world tour in Copenhagen last week I was asked how to change a Power BI report’s connection from a dataset in the service – for instance if you have a test workspace and then …

PowerBI desktop September update has added the functionality of custom ( pages ) tooltips also to card visual.

In the 2018-September release of Power BI Desktop, Microsoft has introduced a new game changing feature in data analytical world: “Aggregations”. Personally I feel that Aggregations will provide lo…

Since last week’s episode of Insight Quest, a primary business stakeholder has reached out to Anna, the BI team manager, and asked if they could ‘see something’. Anna respectfully…

Want to know what Power BI features were released in a certain time period? Check out the Power BI Features report. After some delay, you should see the report embedded on the page but please be patie…

Switching a report from one PowerBI dataset to another PowerBI dataset (@donsvensen) Get data from PDF in Power BI (@CurbalEN) Using Dax To Handle Multiple Parent Hierarchies (@PowerPivotPro) DAX Guid…

It has been a few months since I have updated my Power BI InfoGraphic and with the speed at which this all changes and updates I have always had a challenge to keep it up to date. The following ite…

Last year I compared between Power BI and Tableau here and here, and eventually decided to stop it. There was no point for me to look back at Tableau and compare features, when I felt that Power BI is paving the way so quickly and is keeping Tableau behind. In a race, if you are …