Microsoft Power BI
Reports and KPIs from Dynamics 365

Overview of the advantages and possibilities of Microsoft Power BI | Integration in Dynamics 365

Due to the increasing digitalisation in companies, the amount of data available is also continuously increasing. Power BI provides you with an overview at all times.

The Microsoft Powertool for processing and visualization of large amounts of data can be connected to a multitude of databases and data sources thanks to its extremely versatile interfaces. These include among others:

  • Access databases
  • Azure SQL databases / Data Warehouses / Blob Storages / Spark on Azure HDInsight
  • Excel tables with format .xslx / .xlsm / .csv
  • IBM databases (Db2 / Informix / Netezza)
  • Google BigQuery
  • Microsoft Dynamics 365 / Exchange Online / NAV / Business Central
  • SAP databases (HANA / Business Warehouse application server)

To illustrate the size of the data sets, you have to take a look at the maximum number of data per column: Currently almost 2 million data. That is a lot of data.


Overview of the Power BI main functions

Organizations of all sizes can use Power BI Pro to empower individual users
at reasonable prices, enable the targeted use of the following functions:

  • 360° degree dashboards
  • Analyses are updated in real time with the latest data
  • Connection of countless different (OnPremise) data sources
  • application lifetime management
  • Drilldown dashboards for impressive visual display
  • of company data from various sources
  • Native integration with Excel, Dynamics 365 and PowerApps
  • Mobile access to data thanks to the Power BI Mobile App
  • Self-Service Options
  • Templates for reports, dashboards and reports
  • Share reports, insights and dashboards with other Pro Users

Great Webinar on Power BI


An option for large companies: The Power BI Premium Edition

With Power BI Premium Edition, large global enterprises can switch from per-user licensing to resource-based licensing. In the Premium Edition any number of users can access Power BI. This is a clear advantage for the complex management of a multitude of local data sources with a large number of users:

  • Integration into national Azure Clouds possible
  • Publishing paginated reports
  • Virtual calculations in up to 7 V-cores

The first impression counts | Power BI at work

Professional CRM systems
and individual industry solutions
for sustainable competitive advantages.

MOre of us


awisto business solutions GmbH
Mittlerer Pfad 4
70499 Stuttgart
Tel.: +49 (711) 490 534-0