
To post questions and to locate user groups
My PBI bookmark file, as of July 2019, with about 400 of my *favorite* PBI links. Import this into your browser
Check out Mark Walter’s blog (Story BI) post, “Links to some of the best Power BI resources the web has to offer” which lists mosts of the “must-know” Power BI resources
Learning options
- Microsoft Learn content for Power BI – many “Learning Path” modules available, some on the way to certification
- Find the right Power BI training for you (Microsoft resources)
- Microsoft Dashboard in a Day (DIAD) – the content is excellent. Go through the self-paced content two or three times…literally!
- Special course: Data Modeling & Shaping. But the real point is that you can download the assets of this advanced training and use them as self-paced resources.
- Study material for exam DA-100 Analyzing Data with Microsoft Power BI by Sean Lee at MSSQLTips
Tools for Tabular Data Model Developers
Power BI is an Enigma, so What to Do? (a blog post from Matt Allington)
A few select Power BI Documentation references:
- What is Power BI?
- Power BI certification
- Dashboards
- Create report templates for Power BI Desktop
- Licensing
- What is Power BI Report Server?
- Data
- Row-Level Security (RLS)
- Generate data insights automatically with Power BI (Quick Insights, part of the Power BI Service)
- Visualizations
- Get samples for Power BI
- Visualizations in Power BI reports – documentation on each of the built-in visualizations
- Create tooltips based on report pages in Power BI Desktop
- Create a QR code for a report in Power BI to use in the mobile apps
- Drill mode in a visual in Power BI
- Run Python Scripts in Power BI Desktop
- Run R Scripts in Power BI Desktop
Other important Power BI references:
- Regarding Accounts and Administration
- To set up your own Power BI account in your tenant (five second setup IF your tenant already exists, AND your Power BI administrator enables self-enrollment)
- Power BI Workspace Permissions and Roles by Scott Murray at MSSQLTips
- The Power BI Gateway; All You Need to Know by Reza Rad
- Regarding Visuals, Report and Dashboard Design
- Welcome to the Data Stories Gallery
- Power BI Custom Visuals Gallery
- The Visuals Reference from SQLBI
- Devin Knight’s Power BI Custom Visuals (video) blog, over 110 short videos
- Dynamic hierarchies in Power BI
- Custom Power BI Themes: Page Background Images by Cathrine Wilhelmsen (Base64 image conversion, wallpaper v background, and more)
- Charticulator, a Microsoft research project for creating Power BI custom visualizations
- Advanced Color Theme Generator by PowerBI.Tips
- A few resource links from Miko Yuk and her team at BIBrainz
- Dashboard examples
- Blog, with links to other resources like “Analytics Design Guide” and “5 Reasons You Suck at BI Dashboard Design” and “Top 5 Websites to Bookmark to be a Better Big Data Visualization Expert“
- DIY Freebies to Ignite your Data Storytelling journey! (books, whitepapers, etc.)
- SVG in Power BI – Part 3 – Fill up with Colour by Laura GB at Hat Full of Data
- Regarding Data Modeling
- Power BI and a Star Schema by James Serra at SQLServerCentral
- Here’s another explanation of why your data model should have a star schema by Patrick LeBlanc of Guy In a Cube
- Microsoft Power BI: The Do’s and Don’ts of Power BI Relationships – BRK3019 YouTube by Pete Myers (~60 min.)
- Create custom keys for your Power BI relationships, YouTube video (~10 min.) by Patrick LeBlanc at GuyInACube on turning a flat table into a star schema
- Execute SQL Server Stored Procedure With User Parameter In Power BI by Dhruvin Shah
- Passing parameters to SQL stored procedures in Power BI Desktop by WiseOwl Training
- Apply many-many relationships in Power BI Desktop
- Understanding Cross Filter Direction with a simple example by Dinesh Priyankara
- Different Types of Many to Many Relationships in Power BI – video by Marco Russo presented at SQLBITS
- DAX 101: Automatic time intelligence in Power BI by Alberto Ferrari at SQLBI {don’t use the built in date table(s)}
- {similar to above} Power BI Model Size Bloat And Auto Date/Time Tables by Chris Webb at his Crossjoin blog
- Naming Tables, Columns And Measures In Power BI also by Chris Webb {read the comments, too}
- Add Descriptions for Everything You Create in Power BI by Marc Lelijveld at Data – Marc
- Power BI and a Star Schema by James Serra at SQLServerCentral
- Regarding Data Transformation and the Power Query Editor
- General tip: Always accept pain as early in the development process as possible. I first heard this from Dave Rodabaugh of Atlas Analytics at a SQLSaturday in Columbus. A modern version of this was called “Roche’s Maxim” as described by Stuart Box at BurningSuit
- Doing Power BI the Right Way: 2. Preparing, shaping & transforming source data, a.k.a. “Where should I shape and transform data?” by Paul Turley
- Exporting Your Queries’ M Code From Power Query And Power BI Using Copy/Paste by Chris Webb
- Extracting All The M Code From A Power BI Dataset Using The DISCOVER_M_EXPRESSIONS DMV also by Chris Webb
- 6 ways to go bananas with Column from Examples in Power BI from GuyInACube, a YouTube video
- Split the Date Using Power Query or Get & Transform by Bryan Hong at MyExcelOnline
- Query Parameters
- Great four-part series on Query Parameters from Soheil Bahkshi at bi insight complete with use-cases
- Deep Dive into Query Parameters and Power BI Templates by Miguel Llopis at the Microsoft Power BI Blog
- Power Query Parameters Vs. What If Parameters: Power BI Implementation Use Cases
- The main benefit of Parameters in Power BI / Power Query by Miguel Escobar at Powered Solutions
- Split the Date Using Power Query or Get & Transform by Bryan at MyExcelOnline
- Split the Time Using Power Query or Get & Transform by Bryan at MyExcelOnline
- Many Part Series on Power Query/M by Ben Gribaudo
- Adding an Error Details Column by Ben Gribaudo
- Comparing M Code Between Files by Ben Gribaudo {requires PowerShell and DIFF tool such as with Git)
- Regarding Data Refresh
- DirectQuery, Live Connection or Import Data? Tough Decision! by Reza Rad at RADACAD
- The Power BI Gateway; All You Need to Know by Reza Rad
- Power BI Gateway installation screenshots (this website, a little old now)
Video links and references on Dataflows
- What are the Use Cases of Dataflow for You in Power BI by Reza Rad, 9:37
- Dataflows vs. Datasets by Matthew Roche
- Power BI Dataflows 201 – Beyond The Basics by Matthew Roche, 1:00:11
- Getting Started With Dataflow in Power BI Creating Dataflow – Part 2 of Dataflow Series by Reza Rad
Third-Party Power BI Connectors from CData (quite an extensive list) $$$
Miscellaneous Power BI links and resources
- Macaw Power BI Cheat Sheet
- Another Power BI Cheat Sheet from Štěpán Rešl at DataBrothers
- Whitepaper: 7 Steps to Better Power BI Visuals by Meagan Longoria at Blue Granite
- External Tools: Document your Power BI Model by Marc Lelijveld
- YouTube series by Jon Schwabish at PolicyViz called “One Chart at a Time“. Different presenters introduce a visual type and answer these three questions about it:
- Can you please describe the graph?
- Can you please describe any considerations chart makers need to take into account when creating this type of chart?
- Can you please share an example of this chart you really like?
- “Rapid BI Solutions with Power BI and Power Query” presentation (on YouTube) to GLUGnet in December 2020 By George Squillace
- How to Create an Automated Data Dictionary by Michael Kovalsky at Elegant BI
- (follow-up post) Automated Data Dictionary – Reinvented
- Checkout these awesome keyboard shortcuts! (Power BI Community)
- Assess Knowledge using the Power BI Skills Matrix (Power BI.tips). Gulp, I found this pretty challenging, even after all the time I’ve spent with PBI.
References on Performance
- Power BI Best Practices Guide by MAQ Software (they have other valuable best practice guides, too)
- Data Validation Best Practices Guide (also by MAQ Software)
- Power BI: Data Model Optimization by Data on Wheels (short, mostly talks about Date tables)
Articifical Intelligence (AI) Features in Power BI
Power BI Smart Narrative by Scott Murray at MSSQLTips
What is the difference between a Power BI Report and a Dashboard?
- Power BI Dashboard vs Report vs Workbook by Koen Verbeeck at MSSQLTips
- Dashboard vs Report; Differences At a Glance – Power BI by Reza Rad at RADACAD
- Power BI: Dashboards vs. Reports by the Power BI Team
- Power BI Dashboard vs. Report: The Pros and Cons by Kasper Langmann at Spreadsheeto
- Power BI Dashboard vs. Report at EduCBA
PASS BI virtual chapter from Ginger Grant, “Power BI Practical Storytelling and Visualization Techniques” (a report makeover)
Custom visuals that seem especially useful to those in finance and accounting:
- ZebraBI
- Check out “Top features of Zebra BI visuals for Power BI“
- Check out “Top features of Zebra BI visuals for Power BI“
- ValQ
- 3AG
- Dataviz Boutique – Klaus Birringer and the “Ultimate” series of PBI visuals
Power BI v. Reporting Services, a few references…
- Power BI vs SSRS – Choose the best tool for fulfilling your requirements! at Data Flair
- Differences Between Power BI vs SSRS at EduCBA
- SSRS vs. Power BI – when to use and why? at StackOverflow
Visio Data Visualizer
- Microsoft Visio Data Visualizer (download link)
- Visio Data Visualizer Tips from bVisual.net
- Video (~37:00) Create data-driven diagrams with Microsoft Excel and Visio by Amit Oberoi and Prateek Sharma
Screenshots: Using Power BI with WordPress and Google Analytics
In December 2020 I presented “Rapid BI Solutions with Power BI and Power Query” for GLUGnet. Thank you Sam Nasr and NIS Technologies for sponsoring and recording and editing the video.