Power BI Blog and eBook

Power BI Blog

Welcome to my Power BI eBook and Power BI blog. Here you will find many articles, blog posts and how-tos I have written to help you learn, implement and understand Power BI.

Please reach out if you have any feedback and good luck on your Power BI journey.

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
    12. Data Classification
    13. Setting up Data-Driven Alerts
    14. Post to Teams using Alerts and Flow
    15. Set up Custom Branding in the Service
  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
    9. Mark as Date Table
    10. Change Report Font Size
    11. Download PBIX file from Service
  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
      12. Creating a Simple Date Table
      13. GENERATESERIES
    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. Create, Update and Share Themes through the UI
    9. Comparing Year to Previous Year Reports
    10. URL Link Fields
    11. Report Drillthrough
    12. Cross-Report Drillthrough
    13. Url Parameter Filtering
    14. How to Change a Data Source in a Report
    15. Display Images from URL
    16. Using Tooltips to Show an Image
    17. Embed Power Automate Flows inside Power BI
  11. Visualizations
    1. Timeline Slicer
    2. Table Heatmap
    3. Word Cloud
    4. Changing How Visualizations Interact
    5. Remove Custom Visual from Report
    6. Horizontal Bar Chart
    7. Personalized Visualizations Pane
  12. R
    1. Install R
    2. Install RStudio
    3. R Visualization from Marketplace
    4. Install R Packages for Visualizations
    5. Running an R Visual in Power BI Desktop
  13. Python
    1. Install and Setup Python for Power BI
    2. Using Python as a Data Source
    3. Python and Power Query
    4. Python Visualization
  14. Sharing
    1. Groups, Sharing and Editing Reports
    2. Sharing an App with Users
    3. Deep Dive into Comments and Mentions
  15. 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
  16. Solution Templates
    1. Solution Templates on Github
    2. Sales Management for Dynamics 365
  17. 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
  18. Security
    1. Row Level Security (RLS)
  19. 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
  20. Datasets
    1. Streaming PubNub
    2. Dynamics Flow Streaming
    3. Using Quick Insights
  21. Dataflows
    1. What Are Dataflows and How To Use Them (with Dynamics 365 and Common Data Service)
  22. Troubleshooting
    1. Desktop Data Refresh Issue
    2. Dates in Column Chart Issue
  23. Case Studies
    1. Power BI and American Football
  24. Sample Data
    1. Web Sample Data
  25. Mobile
    1. New features in Mobile App
  26. API
    1. Get GroupId and DataSetId from URL
    2. Refresh a DataSet using Power Apps
    3. Refresh a Dataset using Power Automate
    4. Call Power BI REST API from Postman
  27. 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