User Groups Learning Tools Documentation Important Miscellaneous
Dataflows Best Practices Performance Custom Visuals External Tools Artificial Intelligence Report v. Dashboard
PBI v. SSRS Visio Visualizer
 |  |
| Fall 2020 Logo | Previous Logo |
Metaphor: the “wave” is the Power BI development team and the boat is any competitor of Power BI.
Remember, when Microsoft is “in it”, they’re in it to win it!
User Group Information
To find events and find user groups
To post questions, find gallery items and more…
List of some of the active USA and foreign Power BI user groups, such as 
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 from Microsoft: 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
- (Microsoft) Webinar Series: Mastering Data Modeling with Power BI (multiple “episodes”)
- Study material for exam DA-100 Analyzing Data with Microsoft Power BI by Sean Lee at MSSQLTips
- Don’t forget to view the learning resources on my Tabular Model development resources page
- Virtual Workshops & Training from Microsoft, such as:
- Get Started with Power BI (14 sessions)
- Power BI Advanced
- Introduction to Power Platform L100
My PBI bookmark file, as of July 2019, with about 400 of my *favorite* PBI links. Import this into your browser
Tabular Data Model Developer – Tools & References
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
- Power BI Bookmarks Tips, Tricks, and Best Practices by Steve Campbell at Power BI.Tips
- Advanced Color Theme Generator also from 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
- The Complete Interactive Power BI Visualization Guide from Iteration Insights by Claire Mikalauskas. See an example of every built-in visual.
- 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) $$$
Best Practices
Did I miss any good posts?
- Power BI Best Practices by Matt Allington at Excelerator BI
- The Very Basics of Great Power BI Report Design by Brian Grant at CSG Pro
- Power BI Bookmarks Tips, Tricks, and Best Practices by Steve Campbell at PowerBI.Tips
- Best practices when working with Power Query {Power BI documentation}
- Top 10 Power BI mistakes and their best practice solutions by Michael Kovalsky at ElegantBI
- Best practice rules to improve your model’s performance from Michael Kovalsky at the Power BI Blog
- Power BI Best Practices by Koen Verbeeck at MSSQLTips
- Data model guidelines and best practice” from the Zebra BI Knowledge Base
- Data Import Best Practices in Power BI by Marco Russo at SQLBI
- Best Practices Using SUMMARIZE and ADDCOLUMNS by Marco Russo at SQLBI
- All the Secrets of SUMMARIZE by Alberto Ferrari at SQLBI
- DAX Best Practices Guide by MAQ Software
- 23 Best Practices for Power BI, Part 1, from MAQ Software
- 23 Best Practices for Power BI, Part 2, from MAQ Software
- Power BI – Report performance best practices by Mara Pereira at Data Pears
- My Top 5 Power BI Visual Design Practices: Transforming Good to GREAT by Reid Havens when he was at P3 Adaptive (formerly Power Pivot Pro)
- A New Episode Of The Series Bad Practices In Power BI – a rant by Gil Raviv at Datachant
- Top 10 BI best practices by Mikkel Oldenburg at Targit
- Best practices in Power BI report design (an 11 page ebook by DevScope)
- Numbers Shouldn’t Lie – An Overview of Common Data Visualization Mistakes by Micah Bowers at Toptal
Miscellaneous Power BI links and resources
- Macaw Power BI Cheat Sheet by David Ruijter and Marc Lelijveld
- Giving Back: “Steal” this Reference Card! – 8 page reference card (mostly DAX and data modeling) available from P3 Adapative (formerly PowerPivotPro)
- Several cheat sheets available from Štěpán Rešl at DataBrothers
- Power Query (M Language) cheat sheet by Ivan Bond
- DAX Date Calculations Cheat Sheet by Arthur Graus
- 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?
- Do I need Power BI Premium? by Marc Lelijveld at Data-Marc [infographic]
- “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.
- Power BI Chart Flipper Ideas by Harprett Ghuman
- Power BI Map – The world’s most complete overview of Power BI blogs by BI-Survey.com
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)
Artificial 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
External Tools
- External Tools in Power BI Desktop (Microsoft documentation)
- Power BI Desktop External Tools and Why You Should be Using Them by Kenneth Omorodion at MSSQLTips
- From PowerBI.Tips, Business Ops Beta Release – “One Tool to Install them All”
- Level Up Your External Tools Menu In Power BI by Brian Julius at EnterpriseDNA
- Power BI Sidetools, a free external tool by Didier Terrien from The BI Power (instructional video link, too)
- DAX Generator
- DAX Debugger
- DAX Parser
- Easily export data to Excel
- Transfer DAX and M formulas to files
- View your DAX and M formulas in Visual Studio Code
- External Tools: Document your Power BI Model by Marc Lelijveld at Data – Marc
- Hot Swap Report Connections – External Tools by Steve Campbell at PowerBI.Tips
- Python as an “External Tool” in Power BI Desktop: Part 2 – Create a PBITool.json File by David Eldersveld at DataVeld
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.