Microsoft Power BI
Published in

Microsoft Power BI

Demystifying Power BI — Data and Report Design Tools

A summary of data modeling and report design tools in the Power BI ecosystem

Photo by Miguel Á. Padriñán from Pexels

Data and Report Design Tools

Native Power BI Tools

  • get data from many sources
  • combine data from multiple sources
  • clean, transform and enrich that data
  • add measures and DAX calculations
  • define Row Level Security (RLS)
  • build and publish reports
  • create dashboards and reports
  • create Apps to package up a set of related content for distribution
  • create scorecards and metrics
  • build dataflows and datamarts
  • manage user access, permissions, and security
  • Excel data models have a lower size limit on Power BI service than Power BI premium datasets
  • in Power BI mobile Apps, Excel reports appear as static
  • not all Excel functionality is supported in the Power BI service
  • some data sources are not available in Excel
  • modify reports that were created in SSDT Report Designer or SSRS Report Builder
  • preview reports in HTML or print format
  • export reports to other file formats such as MHTML, PDF, XML, CSV, Word, and Excel

Tools for Analysis & Reporting Services

Third-Party Tools


Next in series

Like this post? Connect with Dhyan



Microsoft Power BI blog publishing news, tips and tutorials carefully chosen by our editors team. If you would like to contribute to our publication contact me on email or

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Dhyanendra Singh Rathore

Analytics Expert. Data and BI Professional. Owner of Everyday BI. Private consultation -