Power BI

This article describes the use of Expression.Evaluate as a very helpful

A few weeks ago, I blogged about my experiences with the Analysis Services Connector. Because the Enterprise Gateway was still in preview back then, I didn't want to use that in production yet.

How to compare multiple tables against each other using Power BI or Power Query in Excel. Kickoff to a series of consolidation and reconciliation techniques

With the release of the Power BI Gateway, it is now possible to publish specific data sources for the entire organization. The gateway works in both live connect (data stored on premises) and refresh

I like to think I’m proficient at writing DAX and building SSAS tabular models. I enjoy a good challenge and appreciate requirements that cause me to stretch and learn. But sometimes I hit a …

In the first entry in this series (to view, follow this link ), I took a look at the how row level security worked with read operations. Now in this entry, I want to expand that to how you use it to limit what a user might write to, or delete from a table.

I wrote an article about Time Intelligence in Power BI Desktop to explain how to fix measures using DAX functions for time intelligence when you have a data model where the relationship uses surrogate keys. THe short description is that all the time intelligence

This post will look at two different approaches for expanding a record from a list using Power BI and a bit of M syntax. In our specific case, a customer wanted to pull data from a record that was listed in the table output of a SharePoint list.

Did you know that when Bill Gates enters a bar, the average customer becomes a billionaire? That is what I call the Bill Gates Effect. (Many thanks to Introductory Statistics)Pss! There is a Power BI

Given some of the questions I

Back in August 2015 we open sourced our data visualization stack, documented the IVisual interface, and let developers start building custom visuals for Power BI. In October 2015, we enabled a

With Power BI gateways, you can keep your data fresh by connecting to on-premises data sources. The gateways provide the flexibility you need to meet individual needs, and the needs of your

One of the custom visuals that I regularly

Since the creation of the KPI Indicator custom visual (originally submitted to the Power BI Custom Visual Contest) I have been getting a lot of feedback and support from users all around. Therefore,

Introduction The case The purpose of the workbook is analyzing the daily sales in a month. I want to see the sales in the current month but also in the previous month. I have the following

The Power BI KPI report is probably on top 10 of the most in-demand use-case for Power BI.

Using PowerBI to simplify your SQL Server Migration Neil Hambly Neil Hambly is the practice lead for a UK Microsoft Data Platform Partner and regularly undertakes such migrations with his clients,

This is a posting for T-SQL Tuesday #75 As the SQL Server & BI Consulting Practice lead in a Tier-1 managed Microsoft Partner consulting company

What if I told you, there was one key skill, that has set me head and shoulders above the Excel crowd when working with Power Pivot and Power BI? Would you

The infographic

This week we

Do you like bold, bright colors infused with simplistic design? The answer better be

This post looks at how to structure your Power Query setup to avoid the "please rebuild this data combination error" when you try to merge two queries.

Update: Visit our Getting Started with Excel and Power BI Series post to access updated training Update 2: Try what's next for Power BI Power Query and Power Map are two of the new Excel features for Power BI announced this morning at the Worldwide...

Power BI Personal Gateway Power BI Personal Gateway acts as a bridge, providing quick and secure data transfer between the Power BI service and on-premises data sources that support refresh. This

LabTech Green - #6ba643

In Power BI Desktop, we have the ability to create calculated