Power BI

We live in a world of choices and we have many tools at our disposal. In Microsoft Business Intelligence solutions using tools like Power BI and SQL Server Analysis Services, you have at least thr…

As some of you already know, we started #LondonPugDataViz at London Power BI User Group for completing two successful years. I am hoping LondonPugDataViz by all of us lead to more success in…

The dataset for the next LondonPUGDataViz is The Newyork time bestseller data from Wikipedia. It looks like only data between 2000 to 2018 years seem better. So it’s up to you,…

Power BI training Resources - all of the best resource accumulated from multiple sources. Learn Power BI and DAX language for free with these resources.

In the previous post, I explained a usage of bookmarks and buttons in Power BI, which was for clearing all slicers. Buttons and bookmarks are the gold combination in Power BI. You can do wide range of…

In this video, Christian Wade joined Adam Saxton to discuss Incremental Refresh with Power BI Premium. You can use Incremental Refresh with Power BI Premium to take your dataset beyond 1GB and avoid failures such as timeouts. Incremental Refresh with Power BI Premium documentation Power BI Desktop – May 2018 Connect with Christian Wade

In this video, Homer McEwan (aka KillaDBA), joins Patrick to learn the clicks for sync slicers in Power BI Desktop. Patrick also shows the new group functionality in the May 2018 release of Power BI D…

DAX Measure Dependencies in SSAS Tabular and Power BI (@biinsightnz) SQL, M or DAX? (@Paul_Turley) Announcing Dashboard Theming in the Power BI Service Power BI Service and Mobile April Feature Summary Power BI Desktop May Feature Summary BONUS ITEMS: Fun with DAX – Compressing Numeric Sequences to Text (@pseamark) Manual Groups and Bins in Power […]

Often when working with a Power BI report you will add a slicer that has a "Blank" item in the selection criteria. This may not be the desired behavior for a slicer. In this Tutorial we walk through why the "Blank" item appears and now to filter that value out of your slicer.

Often when working with a Power BI report you will add a slicer that has a "Blank" item in the selection criteria. This may not be the desired behavior for a slicer. In this Tutorial we walk through why the "Blank" item appears and now to filter that value out of your slicer.

We love hearing feedback from the Power BI community and today we have another quarterly survey to keep improving Power BI with your feedback.

Business intelligence solutions are not fire-and-forget; you will be making regular changes, so follow the tips in this blog and make your life easy. Use the five points in this post to design a flexible solution that is a pleasure to maintain.

I recently came across a customer who was looking for a way to switch the dimensions dynamically using a slicer. In this blog, I’ll be sharing how I could do it in Power BI. This can be understood using the following example: Switching the dimensions of a bar chart between Daily and Monthly based...

Power BI is a cloud-based business analytics service that gives us a single view of the most critical business data. A tool for creating live dashboards and rich, interactive reports, Power BI allows access to data for monitoring the health of a business. Pierstefano Tucci will take readers through the Power BI interface, query creation, publishing your work, and more in Power BI Succinctly.

We are excited to announce that we have released the May update for the On-premises data gateway. Here are some of the things that we would like to highlight with this month’s release Impala SSO…

In this tip we look at how to use Power BI to help us find items that are closely correlated for things like products that are purchased together.

This is a post about a post about a post. Thanks to those of you who are entering comments in the original May 12 post titled SQL, M or DAX? This is a popular topic. And thanks to Adam Saxton for…

Fortunately, there has not been a lot of activity in the Power BI space, which gives me a chance to catch up on some reading (Beginning DAX with Power BI by Phil Seamark) and to have a bit of a re…

In this post I show you different implementations of Time Dimension in Power BI. You'll learn how to create Time dimension in DAX, Power Query and also in SQL Server. You also learn how to UNPIVOT Time dimension in DAX to support dynamic time bands. You may use the same technique in SSAS Tabular, Azure AS and PowerPivot.

Back in March, with the publication of the Dynamics 365 Release Notes document (which you can download here, halfway down the page), we learned a lot about the roadmap of Power BI; my blog post here s…

Row Level Security is a cool feature available in both Power BI and SSAS tabular model. It allows you to authorize different users to different information within your organizational data. In this …

(2018-May-27) With recent Hawaiian volcano activity, it would be interesting to see how other similar events have shaped our Earth planet....

I’ll be leading a two-hour a webinar on Data Modeling at the Power Up! virtual event on June 13th. Most of this session will focus on the ‘how’ and ‘why’ of building e…

in my last post I showed how you can save the results of dbachecks to a database and created a PowerBi report. Inspired by Frank Henninger in the #dbachecks slack channel and Shawn Melton who expla…

This month our reporting features focus on accessibility and more flexibility when formatting your charts. With filtering and sorting options now available, out data view is now more powerful. Several…

It is world’s cup fever: FIFA world cup 2018 in Russia!!! And we dont want to miss anything right? That is where Power BI comes to the rescue :) I am going to build a Power BI file to follow …

Here is my weekly BI-RoundUp, and once again the awesome people from the Microsoft Power BI Team have released some additional gifts. Power BI Desktop June Update Here is another month of big updat…