Power BI Resources

Power BI training resources, presentations and downloads

Power BI in Government

Power BI Training Links

Power BI Guided Learning

Guy in a Cube YouTube Channel

Power BI Training Content

Power BI Dashboard in an Hour Lab

Power BI Paginated Reports in a Day YouTube Training

Power BI Adoption Framework

Excel Training Resources

Power Query

Make Your First Pivot Table

Get More out of Pivot Tables

Going Beyond Pie Charts

Tips and Tricks

50 Time-saving Excel Shortcuts

Presentations

Power BI Developer Scenarios

Python Setup

First, check out the online docs for Power BI and Python integration here.

Then, see the PythonSetup.ps1 file for specific Python module requirements.

Power BI Report Server

D3.js Visual Demo

Using the awesome D3.js custom visual, I recreated the sample file to work with Power BI Report Server for various release versions.

You can download the sample files below

• August, 2018
• January, 2019
• May, 2019

Visuals Marketplace Bulk Download

I created a PowerShell script that allows you to download all Power BI visuals from the marketplace at one time. The script can be found here.

Comparisons

Power BI Report Server vs Power BI Service

Power BI Desktop vs Power BI Service

Shape Maps

Here's the link to Microsoft's online docs for Power BI Shape Maps,

Power BI Shape Maps Documentation

Below are some custom TopoJSON files I have built,

• US District Attorneys Map
  • Sample Power BI Report
• US Trustees Program Regions Map
  • Sample Power BI Report

Mapshaper is a great website to convert existing shapefiles into TopoJSON format,

Mapshaper

Build your own custom world map with select countries with this awesome site!

https://geojson-maps.ash.ms/

Edit TopoJSON files to include additional properties,

http://geojson.io

Write Ups

Splunk Integration

Summarizes how to integrate Splunk search results with Power BI,

Power BI and Splunk

Shape Map World Map

Here's a write up on creating a world map with the shape map visual,

World Map Shape Map Example

ESRI ArcGIS Enterpise Integration

Here's a write up on integrating an on premise ArcGIS Enterprise solution with Power BI in the cloud.

ArcGIS Enterprise Integration

PowerShell for US Government Environments

Here are some samples on connecting to US Government environments with various PowerShell modules,

PowerShell for US Government

Manually Adding M365 Usage Reports in GCC

How to manually create the M365 Usage Reports for GCC specific customers.

M365 Usage Reports