Power BI

Welcome to my Power BI eBook and Power BI blog. I am constantly adding content as more Power BI features are released, so keep checking back.

Contents

  1. Introduction
    1. Why I Love Power BI – Top 10 Reasons
    2. Getting Started with Power BI – What is Desktop, Service, Free, Pro, Premium, Embedded and Mobile
    3. Power BI Training Resources
  2. Administration
    1. Assign Power BI Service Administrator Role
    2. Adding Power BI to Microsoft Teams
    3. Power BI Admin Portal
    4. Assigning Power BI Service Administrator Role
    5. Assign Power BI Licenses
    6. Office 365 Groups and Power BI
    7. Audit Log
    8. Power BI Home – Announcement
    9. Power BI Home – Exploring the Features
    10. Setting Up Email Subscriptions to Reports and Dashboards
    11. Finding the Tenant Region
  3. Configuration
    1. Featured Dashboard
    2. Monospaced Font
  4. Gateway
    1. Installation
    2. Setup Data Sources
  5. Power BI Desktop
    1. Installing Power BI Desktop
    2. DirectQuery Limitation
    3. Enter Data with Ad-Hoc Tables
    4. Version
    5. Query Folding
    6. Detecting Data Types
    7. Connecting to a Website
    8. Relative Date Filtering
  6. Power BI Report Server
    1. Installing Power BI Report Server
    2. Install Power BI Desktop for Power BI Report Server
    3. Creating a Report in Power BI Report Server
  7. Power BI Report Builder
    1. Downloading and Installing
  8.  Development
    1. DAX (Data Analysis Expressions)
      1. Introduction to DAX
      2. Calculated Columns
      3. DAX YEAR
      4. DAX PREVIOUSYEAR
      5. DAX Single Date Return
      6. USERELATIONSHIP with Multiple Dates
      7. UNION
      8. RELATED
      9. Year over Year with SAMEPERIODLASTYEAR
      10. CALENDAR and CALENDARAUTO
      11. TOTALYTD, TOTALMTD, TOTALQTD, DATESMTD
    2. M (Power Query Formula Language)
      1. Start of the Week
  9. Dashboards
    1. Pin Visual from One Dashboard to Another
    2. Create a Dashboard within Power BI Service
  10.  Reports
    1. Forecasting and Analytics
    2. Goals and Targets
    3. Creating a Report in Power BI Service
    4. Exporting Reports to PDF and PowerPoint
    5. DirectQuery vs Import
    6. Hiding Fields
    7. Themes
    8. Comparing Year to Previous Year Reports
  11. Visualizations
    1. Timeline Slicer
    2. Table Heatmap
    3. Word Cloud
    4. Changing How Visualizations Interact
  12. Sharing
    1. Groups, Sharing and Editing Reports
    2. Sharing an App with Users
    3. Deep Dive into Comments and Mentions
  13. Apps and Content Packs
    1. Updating Reports and Content Packs
    2. Install Dynamics 365 for Sales Content Packs
    3. Install Dynamics 365 for Financials Content Pack
    4. Salesforce Content Pack
    5. Creating Apps and App Workspaces
    6. Installing the Sales Analytics for Dynamics 365 Content Pack
    7. Installing the Customer Service Analytics for Dynamics 365 App
    8. Finding Reports and Datasets in Apps
    9. Voice of the Customer Analytics for Dynamics 365
    10. Setting up an App Workspace and Assigning Permissions
  14. Solution Templates
    1. Solution Templates on Github
    2. Sales Management for Dynamics 365
  15. Excel
    1. Power BI Service and Importing and Uploading Excel spreadsheets
    2. Local Excel File Data Refresh
    3. Power BI Publisher for Excel
    4. Getting Data in Excel 2016
    5. Publish to Power BI from Excel 2016
    6. Analyze in Excel Feature
  16. Security
    1. Row Level Security (RLS)
  17. Dynamics 365
    1. Power BI and Dynamics 365 Overview
    2. Power BI Tiles in Dynamics 365
    3. Option Sets in Dynamics 365
    4. Add a Power BI Dashboard to D365
    5. Process Analyzer Content Pack
    6. Dynamics 365 Data Security
    7. Content Pack PBIX Source Code
    8. Building Your First Power BI Report for Dynamics 365
    9. Given Url Neither Points to OData or Feed
  18. Datasets
    1. Streaming PubNub
    2. Dynamics Flow Streaming
    3. Using Quick Insights
  19. Dataflows
    1. What Are Dataflows and How To Use Them (with Dynamics 365 and Common Data Service)
  20. Troubleshooting
    1. Desktop Data Refresh Issue
    2. Dates in Column Chart Issue
  21. Case Studies
    1. Power BI and American Football
  22. Sample Data
    1. Web Sample Data
  23. Resources
    1. Useful Power BI Links and Resources
    2. Top Power BI Learning Resources
    3. Overview of REST API
    4. Power BI REST API Reference