Microsoft Power BI – Business Intelligence from the Microsoft Cloud.

Part of the Microsoft Power Platform:


Your challenge without Microsoft Power BI.

Do you have an overview of the performance of all your company’s branches? Can you evaluate the reasons for your customers’ complaints and use them to initiate optimization measures? Can you visualize key performance indicators (e.g. development of market share, sales, sentiment, competition) broken down by region and time period and thus monitor the development of your company at any time?

No? Then let’s change that in a jiffy. Then your data is currently scattered in various sources and you lack an overview, right? Making well-founded decisions is hardly possible or costs an enormous amount of time. After all, you first have to painstakingly bring all the data together in order to then evaluate it. And don’t forget that you are often dealing with business-critical decisions that are very important for the future development of your company. But don’t worry, it doesn’t have to stay that way.


The solution: Microsoft Power BI.

Microsoft Power BI is an interactive business intelligence tool for data visualization. It may sound a bit abstract at first. What can the tool do? It allows you to keep an eye on all important developments in your company at all times. This is because you establish connections with numerous data sources and present your company data with clear live dashboards and reports. By bringing together data from a wide variety of sources, it especially resolves the inefficiencies of isolated data sets. You can also share your insights with colleagues and supervisors to take collaborative, targeted action.

See here

How Microsoft Power BI works.

It’s very easy to use: If you’re looking for specific data, Microsoft Power BI lets you ask a question in natural language and the software suggests visualizations. This way, you can quickly and easily present your favorite data in a clear way. Besides, you’ll be able to determine forecasts and trends from your existing data, to proactively determine the company’s development. In order to be up to date at all times, Microsoft Power BI also offers the option of conveniently accessing the business intelligence tool from any mobile device. What more could you want?

Numerous connectors:

Link numerous data sources.

  • Azure

    • Azure Analysis Services-Datenbank
    • Azure Blob Storage
    • Azure Cosmos DB
    • Azure Cost Management
    • Azure Data Explorer (Kusto)
    • Azure Data Lake Storage Gen1
    • Azure Data Lake Storage Gen2
    • Azure Database for PostgreSQL
    • Azure HDInsight (HDFS)
    • Azure HDInsight Spark
    • Azure SQL Data Warehouse
    • Azure SQL-Datenbank
    • Azure Time Series Insights (Beta)
    • Azure Table Storage
    • HDInsight Interactive Query

  • Databases

    • Access Database
    • Amazon Redshift
    • AtScale-Cubes
    • BI-Connector
    • Data Virtuality LDW (Beta)
    • Denodo
    • Dremio
    • Essbase
    • Exasol
    • Google BigQuery
    • IBM DB2 Database
    • IBM Informix Database (Beta)
    • IBM Netezza
    • Impala
    • Indexima (Beta)
    • InterSystems IRIS (Beta)
    • Jethro (Beta)
    • Kyligence
    • Linkar PICK Style/MultiValue Databases (Beta)
    • MarkLogic
    • MySQL Database
    • Oracle Database
    • PostgreSQL Database
    • SAP Business Warehouse Application Server
    • SAP Business Warehouse News Server
    • SAP HANA Database
    • Snowflake
    • SQL Server Analysis Services Database
    • SQL Server Database
    • Sybas Database
    • Teradata Database
    • Vertica

  • Files
    • Excel
    • Folder
    • JSON
    • PDF
    • SharePoint-folder
    • Text/CSV
  • Microsoft Power Platform
    • Common Data Service
    • Power BI-Dataflows
    • Power BI-Datasets
  • Online services

    • Adobe Analytics
    • appFigures (Beta)
    • Asana (Beta)
    • Azure DevOps (only for boards)
    • Azure DevOps Server (only for boards)
    • World – Retrieve dataset (Beta)
    • Dynamics 365 (online)
    • Dynamics 365 Business Central
    • Dynamics 365 Business Central (local)
    • Dynamics 365 Customer Insights (Beta)
    • Dynamics NAV
    • Emigo Data Source
    • Entersoft Business Suite (Beta)
    • FactSet Analytics (Beta)
    • GitHub (Beta)
    • Google Analytics
    • Industrial App Store
    • Intune Data Warehouse (Beta)
    • LinkedIn Sales Navigator (Beta)
    • Merketo (Beta)
    • Microsoft Azure Consumption Insights (Beta)
    • Microsoft Exchange Online
    • Microsoft Graph Security (Beta)
    • Mixpanel (Beta)
    • Planview Enterprise One – CTM (Beta)
    • Planview Enterprise One – PRM (Beta)
    • Planview Projectplace (Beta)
    • Product Insights (Beta)
    • Projectplace für Power BI (Beta)
    • Quick Base
    • QuickBooks Online (Beta)
    • Salesforce-reports
    • Salesforce-objects
    • SharePoint-Online-list
    • Smartsheet
    • SparkPost (Beta)
    • SweetIQ (Beta)
    • TeamDesk (Beta)
    • Twilio (Beta)
    • tyGraph (Beta)
    • Webtrends (Beta)
    • Webtrends Analytics (Beta)
    • Witivio (Beta)
    • Workplace Analytics (Beta)
    • Zendesk (Beta)
    • Zoho Creator (Beta)

  • Other

    • Active Directory
    • Cognite Data Fusion (Beta)
    • Empty query
    • FHIR
    • Hadoop-Datei (HDFS)
    • Hive LLAP (Beta)
    • Information Grid (Beta)
    • Jamf Pro (Beta)
    • Microsoft Exchange
    • MicroStrategy für Power BI
    • OData-Feed
    • ODBC
    • OLE DB
    • Paxata
    • Python-Skript
    • QubolePresto (Beta)
    • Roamler (Beta)
    • R-script
    • SharePoint.-list
    • Shortcuts Business Insights (Beta)
    • Siteimprove
    • Solver
    • Spark
    • SurveyMonkey (Beta)
    • Tenforce (Smart)List
    • TIBCO(R) Data Virtualization (Beta)
    • Vena (Beta)
    • Web
    • Workforce Dimensions (Beta)

Power BI in practice:

Use cases for Power BI.

Power BI can be used for a wide variety of scenarios. We have put together some use cases for you. Can you find your situation in an example?

Exemplary scenarios:


Auswertung mit Power BI

Evaluation with Power BI

  • Dashboard on business development

    As a managing director, it is certainly important to you to increase your market share and to grow as a company. With the help of Power BI, you can align your Dynamics 365 Business Central or Dynamics NAV dashboard in such a way that your favorite success-critical key figures (e.g. development of market share, sales, mood, competition) are visualized broken down by region and period.

  • Evaluations per tenant (e.g. branch offices)

    In the standard version of Dynamics 365 Business Central or Dynamics NAV, it is not possible to make cross-tenant evaluations – for example, across several branch offices.

    With the help of Microsoft Power BI this problem can be solved without programming in Dynamics NAV or Dynamics 365 Business Central. Finally, in Power BI – unlike the standard – data of all clients can be merged and a company-wide evaluation can be made. For example, orders on hand or sales can be evaluated according to postcodes and displayed using a variety of display options (e.g. table, map).

  • Evaluation of reasons for complaints

    Microsoft Power BI makes the causes of problems quickly visible – for example when analyzing the reasons for complaints. It may turn out that the complaint rate for a product is particularly high compared to other products – because the article was used more than average or because the material is prone to errors?

    Power BI makes it easy for you to find out – even where the article in question is installed.

  • Overview of personnel figures

    As a human resources manager, it will be close to your heart to track key performance indicators that are critical to success. Use Power BI to generate analyzes – for example, of the number of new hires compared to the previous year, by gender, by age or by percentage development.

  • Procurement analysis

    As a warehouse manager, you certainly want to monitor the most important warehouse key figures. Generate reports on your spend, supplier discount usage by region, city, month or category.

    This allows you to answer questions such as:

    • Do supplier rebates vary by month or remain the same?
    • Do some cities offer higher rebates?
  • Sales dashboard

    In addition, Microsoft Power BI can be used for excellent sales management. For example, a map of Germany with information on target and actual sales figures in the dashboard could be integrated into Dynamics 365 Business Central or Microsoft Teams for every sales person in a company. In this way, they can see at any time when they are performing and how, and where they still need to take action.

    Of course, settings such as visibility, i.e. whether each salesperson is also allowed to see how his colleagues are performing or only see his figures, can be controlled.


Your benefits through Power BI.

  • Visualization options

    Create comprehensive tables, interactive charts and easily incorporate mapping services.

  • Sharing of visualizations

    Share visualizations and your findings with your team, other departments or the management.

  • Fewer manual activities

    You relieve your employees of manual activities, as they only have to define settings once within a few clicks.

  • From anywhere at any time

    You can also access all important information and key figures on the move – in real time and via touchscreen.

  • Usage of multiple data sources

    You can link data from different tables (e.g. stock value and item price), prepare them visually and export them to Excel. You are not restricted to one application, but can aggregate data from a wide variety of applications (e.g. Dynamics 365 applications).

  • Identifying the need for action

    By taking a regular look at your dashboards, you can keep an eye on the development of your company or department and immediately see where action is needed. A frequent area of usage is sales control or the monitoring of open orders or deliveries. Thus, desired data can be controlled centrally and continuously.

  • Well-founded decisions or decision papers

    Enable everyone in your organization to make compelling operational and strategic decisions based on networked and robust real-time data. You can also convince third parties simply by using data-supported insights. Present your power BI analyses and inform customers and colleagues with meaningful and impressive dashboards.


An excerpt of our references.

Meistersinger anaptis Erfolgsgeschichte

Watchmaker Meistersinger

„It is of interest to us to know how often which variant combinations (case and bracelet) are sold. Likewise, incoming orders by country are important. Through Power BI, our evaluation needs have been solved. Minimal adjustments were made so that we now finally have the possibility to see which variant combinations have achieved which sales/turnover in which countries.“

any questions?

Find answers in the FAQ.

  • For which companies is Power BI suitable

    Power BI is suitable for all companies that want to gain valuable insights from their data.

  • What do I need to use Power BI?

    All you need to use Power BI is a web browser and an email address.

  • On what devices can I use Power BI?

    You can use Power BI on your desktop or laptop. For mobile devices, Power BI offers native apps for Android smartphones and tablets, iOS and Windows 10 devices.

  • Can I use Power BI in combination with Dynamics 365 Business Central?

    In Microsoft Dynamics 365 Business Central, there is the option to integrate Power BI for quick and easy access to data. You can then in turn create permissions for the various dashboards, such as read, write, and delete.

  • Can I use Power BI with my on-premises Dynamics NAV environment?

    Yes, you can. In order to use Power BI with your local Microsoft Dynamics NAV environment, you must first enable the OData* service for the web service. The OData feed is used to provide the data base from the SQL Server. Which data is available can be checked under the item “Web Services” in the client. There you can also find the OData feed URL that Power BI needs to query the data. Initially, only the object type “query” is relevant for Power BI. In the standard system, many queries are already available, such as a listing of all sales orders by sales person. However, you can also create your own queries in the development environment within a few clicks. These newly created queries must then be created in the web services before you can get started.

    *OData is a protocol used to exchange data between different systems
  • Is Power BI included in Microsoft 365 or Office 365 subscriptions?

    Power BI Pro is included in Office 365 E5. For an overview of licensing options, please visit our pricing page.


What does Microsoft Power BI cost?

Power BI Einführung Workshop
anaptis Service:

Your customized workshop for Microsoft Power BI.

In our customized Microsoft Power BI workshop, you will learn how to generate added value from your data. We introduce you to the tool, show you how it connects to Dynamics 365 Business Central and work together on your use case.

Keep browsing:

Learn more about the other components of the Power Platform:

Microsoft Power Apps Logo

Power Apps

Create your own mobile and web apps for your business needs.

learn more


Microsoft Power Automate Logo

Power Automate

Convert regular, recurring routine tasks into workflows.

learn more


Microsoft Power Virtual Agents Logo

Power Virtual Agents

Create chatbots without any programming knowledge.

learn more


What can we do for you?

Ask for a consultation or workshop for Microsoft Power BI.

Get to know us and our solution! We will be happy to present the product to you in a free initial consultation. You can assess whether we as a partner and Microsoft Power BI as a solution are a good fit for you. You are also welcome to request our Microsoft Power BI Workshop directly.

  • Insight into the functionality
  • Thematization of your priorities
  • Individual consulting for you

We look forward to your inquiry!

Geschäftsführung anaptis

Request a consultation or workshop

    We may need your phone number to schedule an appointment and determine your needs.

    Fields marked with an * are mandatory fields and must be filled out!