Power Query

Moving from Power Query in Power BI Desktop to Dataflow

This session starts with an introduction to dataflow, what it is, and how it can be helpful....

13 August, 2020

Visualizing Anomaly Detection and Interactive Documentation in Power BI

BEN LAWRENCE (DataDx) - Visualizing Anomaly Detection and Interactive Documentation in Power BI Anomaly detection can be a confusing concept and is hard to present to users in a meaningful way. In this presentation, see how DataDx has leveraged the isolation forest...

08 June, 2020

Learn How to Track Errors with a Power Query Error Table

MARK WALTER (Industrial Finishes and Systems) - Learn How to Track Errors with a Power Query Error Table Power Query is a remarkable ETL tool within Power BI; however it is all too easy to overlook errors that might be buried within our...

08 June, 2020

Calendarfornia Dreamin – M Calendar Script for Power Query

People ask me all the time which M script calendar table I use in Power Query. Honestly, most of the time I just grab the most recent one I've used and add/remove columns as needed. Though I thought it might make sense...

08 May, 2020

UX Design for Power BI Mobile

BEN VEGA (Umpqua Bank) - UX Design for Power BI Mobile The 2019 release wave for Power BI Mobile delivered on their promise for “simple, fast, and intuitive report experiences.” Ben will provide an overview of the Power BI mobile desktop application. Learn how...

29 March, 2020

Dynamic Columns for Dynamic Visualizations in Power BI

ROBIN ABRAMSON (Pragmatic Works) - Dynamic Columns for Dynamic Visualizations in Power BI Empower your users through dynamic visualizations in Power BI. In this short, 30 minute session we'll go over a technique to allow your users to choose the attribute contained in...

10 March, 2020

Untangling Nested Headers in Power Query

KIRILL PERIAN (Pragmatic Works) - Untangling Nested Headers in Power Query We have all seen those pivot tables with multiple headers that make us pause, scratch out heads and wonder how in the world are we going to consume such a monster into...

09 March, 2020

Scraping Data The Easy Way With Power Query

RADU BOBIRNAC (Malarkey Roofing Products) - Scraping Data The Easy Way With Power Query Using BeautifulSoup library in Python can give you a lot of flexibility. The downside is, if you don't have them already installed, is needing a pip install for soup,...

01 December, 2019

Visualizing Sustainability Practices in Power BI

MAOLOUD DABAB (Portland State University) - Visualizing Sustainability Practices in Power BI Maoloud is the Campus Sustainability Office's first Sustainability Data Analyst at Portland State University. Using his expertise to translate sustainable development concepts into practice, his goal is to accelerate a culture...

14 October, 2019

Migrating from an Excel to SQL Data Source in Power BI

Working off of an Excel data dump can be a great way to get started building a report while the more official SQL table gets built. The problem is that when you are done, repointing from Excel data to SQL data is...

07 October, 2019

Unlocking New Visualizations and Features in Power BI

REID HAVENS (Havens Consulting) - Unlocking New Visualizations and Features in Power BI Power BI is a great sandbox environment for report design. However, knowing how to leverage visuals and features in a way that adds additional value can be challenging. New visualizations...

30 August, 2019

A Power BI Spin on Accounting and Finance Reports

MARK WALTER (Industrial Finishes and Systems) - A Power BI Spin on Accounting and Finance Reports During Mark's talk, he will demonstrate how Industrial Finishes and Systems, Inc. (IFS) has used data and Power BI to provide everything from Corporate analytics, to external...