Microsoft Power BI

ref: ExcelIsFun, fluentpro

Different Power BI products

  1. Power BI Desktop
    • Free
    • Publish to the
    • Can share .pbix file so others with the “free” Power BI Desktop can view
    • Create Web Embed Code you can post at Public website
      • 2022-09-03 update: All of "Share" features now requires a Power BI Pro license 1
  2. Power BI Pro
    • USD 10 / month / user
    • Collaborate on shared data
    • Audit and govern how data is accessed and used
    • Package content and distribute to users with apps
    • Publish to and have others view on any device
    • From published report viewers can download Data Model into Excel or as a .pbix file.
  3. Power BI Premium
    • Contact Sales, USD 5k / month
    • Unlock higher limits for Power BI Pro users
    • Access interactive and paginated reports online or use Power BI Report Server for on-premises reporting

Power BI, Power Query, Power Pivot, What to use when?

Power Query and Power Pivot complement each other. Use both to shape your data in Excel so you can explore and visualize it in PivotTables, PivotCharts, and Power BI

  • Power Query is the recommended tool for locating, connecting to and importing data.
  • Power Pivot: is great for modeling the data you’ve imported
Power QueryPower PivotDesktop &
RoleImport and shape dataData modeling and calculationsComplete business intelligence tool
LanguageMDAXM and DAX
Key strengths- Nice easy to use interface
- Powerful tools to import and clean data
- All Excel users can benefit from this tool
- Easily handle millions of rows of data
- Modeling tools for efficient data storage and analysis
- Powerful DAX calculations going beyond standard Excel
- Incredible visualization options
- Simple built-in interactive options
- Powerful DAX calculations
- Simple publishing to and mobile devices

A diagram explaining how these Powerful tools are related power-platform

With respect to report usage, typical usage can be seen below.


ToolUsed byPurpose
Power BI ServiceReport consumersConsuming all types of reports: interactive, paginated and Excel
Excel OnlineReport consumersConsuming Excel reports from SharePoint, Teams, or the Power BI service
Power BI DesktopModel builders
Interactive report designers
Building Power BI dataset
Building interactive reports
Power BI Report BuilderPaginated report designersBuilding paginated reports
ExcelAnalystsBuilding Excel reports
Analyzing Power BI datasets


Add-on for DAX

  • DAX Formatter is a free tool by SQLBI that transforms raw DAX formulas into clean, beautiful and readable code.
  • is a free online playground to write, run and share DAX queries.
  • DAX Studio is a tool to write, execute, and analyze DAX queries in Power BI Designer, Power Pivot for Excel, and Analysis Services Tabular. It includes an Object Browser, query editing and execution, formula and measure editing, syntax highlighting and formatting, integrated tracing, and query execution breakdowns.
  • Power BI Sidetools is an external tool intended to increase productivity during reports development in Power BI desktop. It combine sereral tools, such as DAX generator, DAX debugger, DAX parser

Add-on for Dashboard reporting:

  • Charticulator create custom chart designs for your reports using data modeled in Power BI.
    • Free with many templates charticulator-example
  • Zebra BI offer many report templates both free and paid
  • Other Level’s | Youtube channel, which give inspirations and tutorial on dashboard visuals
    • Individual Pricing plan for each template other-level-example
  • How to Power BI | Youtube channel, which share tutorial on how to design page navigation, clean menu and custom visual in Power BI howtopopwerbi-example
  • Entreprise DNA | Power BI Showcase, some great dashboard from which I get inspiration entreprise-dna-showcase
  • inforiver: besides of visualization, this add-in put Power Bi on steroid with Excel-like features, which are simulation, planning, and writeback capabilities. Beside of their own licenses, Inforiver requires a PBI License if you want to publish and share the reports like any other visual. It is interesting to compare this solution vs Causal inforiver-pricing
  • Deneb, another library to create custom visual for Power BI

  1. Charticulator
  2. Context in DAX
  3. Deneb
  4. Guides
  5. How to evaluate your Power BI skills
  6. Relationship in Data Model
  7. Usage Metrics


  1. : Microsoft˄