Power BI

Welcome to my Power BI eBook.

Contents

  1. Introduction
    1. Why I Love Power BI – Top 10 Reasons
  2. Administration
    1. Assign Power BI Service Administrator Role
    2. Adding Power BI to Microsoft Teams
    3. Power BI Admin Portal
    4. Assign Power BI Licenses
    5. Office 365 Groups and Power BI
    6. Audit Log
  3. Configuration
    1. Featured Dashboard
  4. Gateway
    1. Installation
    2. Setup Data Sources
  5. Power BI Desktop
    1. Installing Power BI Desktop
    2. DirectQuery Limitation
  6.  Development
    1. DAX (Data Analysis Expressions)
      1. Introduction to DAX
      2. Calculated Columns
      3. DAX YEAR
      4. DAX PREVIOUSYEAR
      5. DAX Single Date Return
    2. M (Power Query Formula Language)
      1. Start of the Week
  7. Dashboards
    1. Pin Visual from One Dashboard to Another
  8.  Reports
    1. Forecasting and Analytics
  9. Sharing
    1. Groups, Sharing and Editing Reports
  10. 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
  11. Solution Templates
    1. Solution Templates on Github
    2. Sales Management for Dynamics 365
  12. 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
  13. Security
    1. Row Level Security (RLS)
  14. 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
  15. Steaming Datasets
    1. PubNub
    2. Dynamics Flow Streaming
  16. Troubleshooting
    1. Desktop Data Refresh Issue
  17. Case Studies
    1. Power BI and American Football
  18. Resources
    1. Overview of REST API
    2. Power BI REST API Reference
    3. Useful Links