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
Tools for Tabular Data Model Developers
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?
- Row-level security (RLS) with Power BI
- Row-level security (RLS) in Power BI Report Server
- 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):
- 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
- Regarding Data Modeling
- Create custom keys for your Power BI relationships, a 10 minute YouTube video 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
- Microsoft Power BI: The Do’s and Don’ts of Power BI Relationships – BRK3019 YouTube by Pete Myers
- 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
- Regarding Data Transformation and the Power Query Editor
- 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
- 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) $$$
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
Screenshots: Using Power BI with WordPress and Google Analytics