Power BI

Planning, forecasting & simulation are some of our key focus areas. Recently, we did some benchmarks what the optimal configuration (Azure SQL Table / Azure SQL Table in Power BI / SSAS connected to Azure SQL with Direct Query) for typical planning scenarios in Excel is. Acterys (a solution by one of our group companies) enables users […]

I was delivering my standard Power BI training course, and there was a question from one of the users which was ‘Is there a way of clearing all the slicers you have selected, so if you are do…

As expected this week with SQL Pass, there has been a whole host of new capabilities and features in Power BI, so please see my roundup below with the relevant links below. And even though there is…

BI Power Hour Quick Tips for Aggregations & Composite Models in Power BI (@GilbertQue) Create a Power BI Slicer Panel (@ExceleratorBI) Create Event Calendar In Power BI (@DhruvinShah16) On-premises data gateway October update is now available Power BI Desktop October 2018 Feature Summary BONUS ITEMS: Transform NAV accounts totaling to list of accounts (@TheBIccountant) Optimizing […]

In this video, we are joined by Buck Woody. Buck is a data scientist at Microsoft. We work together to show how you can easily visualize Microsoft R in Power BI. We use Microsoft R Open and then move onto Power BI Desktop. The example used in Microsoft R Open is the Anscombe’s quartet. Download […]

In budgeting reports, a common requirement is to show future sales forecast and actual sales volume on the same line chart. This article describes how to ac

Learn how to create an automated report in Google Ads (AdWords) that gets imported into Power Bi using Ads Script and Google Sheets. It’s based on an Excel Power Query report done by Dan Zrust – so a big shout out to him. As many of my clients use Google Ads conversion tracking code I can’t … Continue reading "Import Google Ads Data Into Power BI For Free"

We are excited to share you the November 2018 version of Power BI helper with many interesting features. With this version, you get the list of all pages and list of all bookmarks. You can find all bo…

We have a massive Power BI Desktop update this month. Composite models, which allow you combine direct query and import sources together in one model, is now generally available. Two of the top featur…

The ability to add columns and measures to display folders in the new Modelling view is one of my favourite features of the November 2018 release of Power BI Desktop: it makes complex models a lot mor…

Well, literally, it all started with a tweet from Amir Netz - the father of SSAS and Power BI... The link to the tweet It seems like November 2018 will be a huge Power BI month with many new features …

A few months ago, I started a series of posts about “translating” Tableau functionality to Power BI functionality and terminology (FIXED LOD example). Continuing that series, one of the…

Well this month has sure been a busy month with a whole host of additional updates for Power BI. I personally am really looking forward to the next few months to better understand how all of this w…

The first step we take in every Power BI report, is connecting to the data source. But maybe you have to change your data source after a while. For example when your transferring your solution from…

The new modeling view in Power BI Desktop is designed to work with enterprise datasets that grow in complexity

Happy 20th birthday Analysis Services!

Be Insights Driven, not Data Driven, and definitely not Tool Driven. Tableau vs Power BI vs Qlik

I have seen a lot of questions in the Power BI Community asking how to connect to a SQL Server Read-Only or Secondary replica, and whilst this is not currently available in the Sql.Database M conne…

Have you ever needed to get data out to an internal customer quickly to meet an urgent business need, in an easy to access, updateable format? Of course! There are lots of ways to do this, and I’ve tr…

In this video, Patrick looks at a small feature called slicer restatement in Power BI. This feature will help you to determine what was selected in a slicer. While this feature was added back in April 2018, we are betting that most folks don’t know slicer restatement.

Today a quick one that I came across while writing a different blog post that I will blog later. I know we have talked about it again and again but...

I got sent a challenge to recreate a report that a customer had built in Excel. They had constructed a Gantt-chart-like view of their projects and wanted to see how we could reproduce it in Power BI I…

Makeover Monday this week focused on a variation of the “Big Mac Index”, where costs for various activities are compared in different cities. The original article presented data in a st…

I have seen a lot of questions in the Power BI Community asking how to connect to a SQL Server Read-Only or Secondary replica, and whilst this is not currently available in the Sql.Database M connector, it is available in the OLE DB connector. NOTE: This could potentially be used for a whole host ...

The dimensional model has been around for quite some time and continues to confer benefits to its adherents today. Made popular by Ralph Kimball years ago, the dimensional model was central to Kimball’s proscribed approach to data warehouse architecture.

Structure is a foundational element to much of what designers of analytical systems and solutions do – but it can be easy to lose sight of the “Why?” of it all. If we don’t need to face the difficult task of imposing structure on our data to analyze it, then what do we gain by doing so?