Category: Power Query

BI Projects, Gartner, Microsoft BI Platform, MVP Community, Paginated Reports, PASS, Power BI, Power Query, Self-service BI, SSAS Design, Tabular Models

DevOps & CI/CD for Power BI

Paul Turley

DevOps isn’t difficult to implement for small and medium-scale projects, and simple things like managing version control in a code repository can save hours of lost time. Organization who are accustomed to managing large application development initiatives might expect to have a fully automated build and deployment process in concert with an Agile delivery process, managed with specialized tools like Jira, GitHub and Azure DevOps.

Azure Data Factory, Azure Databricks, BI Industry, Business Analytics, Dimensional Modeling, Microsoft BI Platform, Power BI, Power Query, Self-service BI, SQL Server, Tabular Models

Getting Data Into Shape for Reporting with Power BI

Paul Turley

Even for small, informal BI projects, shaping the data into a dimensional model alleviates complexity, speeds up slow calculations and reduces the data model storage size. I conclude this post by reviewing seven data architectures and the data shaping methods with different degrees of scale.

BI Industry, BI Projects, Microsoft BI Platform, Power Query, Self-service BI

Doing Power BI the Right Way

Paul Turley

This is an introduction to a series of posts and pages that will provide a comprehensive set of best practices for successful Power BI solutions. In previous posts. Let’s start with a simplified flowchart and condensed decision tree. This first whiteboard drawing is the first half of the Power BI design process, ending with the data model, before measures, visualization and solution delivery. There is a lot more but I think this is a good starting point. Let’s start the conversation here and then I will enhance this post with a more complete list of topics.

Power BI, Power Query

Web API Data Sources with Power Query and Scheduling Data Refresh in the Power BI Service

Paul Turley

Using a Web API is a convenient way to expose and consume data over an Internet connection.  Exercising some essential…

BI Industry, Business Analytics, Power BI, Power Query, Self-service BI, SolidQ

Mastering Power Query in a Day – Full-day training in Seattle

Paul Turley

Following the Power BI World Tour, Seattle event on Oct 30, please join me for a full-day of deep learning. …

BI Projects, Business Analytics, Microsoft BI Platform, Power BI, Power Query, SQL Server

How to Configure the Power BI Gateway to use Dataset Connection Parameters

Paul Turley

A service provider or vendor might want to publish multiple copies of a report that should connect to different database…

BI Industry, BI Projects, Business Analytics, DAX, Microsoft BI Platform, Power BI, Power Query, SQL Server, T-SQL

SQL, M or Dax? – part 2

Paul Turley

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 mentioning this post in his Guy in A Cube Weekly Roundup.

Business Analytics, Power BI, Power Query, SSAS Design

How to add KPI indicators to a Table in Power BI

Paul Turley

Yesterday a friend asked for a little help getting started with Power BI.  He’s a DBA and system administrator and wanted to cut his teeth on Power BI with a really simple dashboard-style scorecard report.  Using a list of database servers with license expiration dates, he thought it would be a simple matter to calculate and show the expiration status for each server using a simple traffic light indicator.  The envisioned server list might look something like this:

Makes perfect sense, right?  This is a basic use case and a good application for simple KPIs; with the one minor caveat that POWER BI DOESN’T SUPPORT THIS!

This topic has become a bit of a soapbox topic for me

Microsoft BI Platform, Power BI, Power Query

The Future of Power Query – Interviews with Chris Webb at PASS Summit 2017

Paul Turley

In a series of interviews during PASS Summit 2017 in Seattle, the week of October 30 through November 3, I…

%d bloggers like this: