Microsoft Power BI

BI-Visualisierung und Berichterstattung für Desktop, Web oder mobile Geräte

4,5 /5 (765 Bewertungen) Eine Bewertung schreiben

Microsoft Power BI Übersicht

Was ist Microsoft Power BI?

Microsoft Power BI verwandelt Daten in umfassende interaktive Visualisierungen, indem es Business-Analyse-Tools nutzt, um Dashboard-basierte Erkenntnisse auf allen Geräten zu teilen

Microsoft Power BI Übersicht

Kosten

Beginnt ab
9,99 $/Monat

Preisoptionen

Gratis Testen
Kostenlos
Abonnement
Preis-Leistungs-Verhältnis

Microsoft Power BI Funktionen

Geräte
Unternehmensgröße
K M G
Märkte
Vereinigte Staaten von Amerika, Kanada, Vereinigtes Königreich, Australien, China und 5 weitere , Indien, Japan, Deutschland, Brasilien, Mexiko
Unterstützte Sprachen
Arabisch, Chinesisch (traditionell), Chinesisch (vereinfacht), Deutsch, Dänisch und 22 weitere , Englisch, Finnisch, Französisch, Hebräisch, Indonesisch, Irisch, Italienisch, Japanisch, Koreanisch, Niederländisch, Norwegisch, Polnisch, Portugiesisch, Russisch, Schwedisch, Spanisch, Taiwanisch, Thai, Tschechisch, Türkisch, Ukrainisch, Ungarisch

Medien

Microsoft Power BI Desktop shown on Thinkpad
Microsoft Power BI Executive Metrics Dashboard
Microsoft Power BI Mobile for iPad
Microsoft Power BI Query Editor
Microsoft Power BI reporting visualizations
Microsoft Power BI shown on Microsoft Surface
Power BI Desktop Welcome screen
Videos zu Microsoft Power BI Videos zu Microsoft Power BI Videos zu Microsoft Power BI Microsoft Power BI Screenshot: Microsoft Power BI Desktop shown on Thinkpad Microsoft Power BI Screenshot: Microsoft Power BI Executive Metrics Dashboard Microsoft Power BI Screenshot: Microsoft Power BI Mobile for iPad Microsoft Power BI Screenshot: Microsoft Power BI Query Editor Microsoft Power BI Screenshot: Microsoft Power BI reporting visualizations Microsoft Power BI Screenshot: Microsoft Power BI shown on Microsoft Surface Microsoft Power BI Screenshot: Power BI Desktop Welcome screen

Microsoft Power BI Bewertungen

Microsoft Power BI Bewertungen

Gesamtbewertung
4,5
/
5
Ausgezeichnet
424

Sehr gut
291

Durchschnitt
41

Gering
7

Schlecht
2

Preis-Leistungs-Verhältnis
4,4
Funktionen
4,4
Bedienkomfort
4
Kundenbetreuung
4,1
93% haben diese Anwendung empfohlen
Michael K.

Ugly numbers to pretty pictures

Management loves it, I love developing with it but getting certain others to adopt it can be a bit of a challenge.


Mit Google übersetzen
Deepak F.

The visualization and analytics product that is constantly evolving - for the better

With Power BI we identify patterns, issues and opportunities in sales, marketing, operations, supply chain, people management and finance data. The ways to look at the data and the drilling capabilities make this a wonderful tool


Mit Google übersetzen
Dan S.

The best gets better

It's easily the most feature rich overall. Other products like Tableau and Qlik have their advantages, but I'm hard pressed to find much fault with Power BI, other than the premium licenses being ridiculously expensive. The word is Microsoft is addressing that issue later in 2020/2021.


Mit Google übersetzen
Verifizierter Rezensent

A pretty reporting tool for some (!) Microsoft Products, but pretty much useless outside of...

In light of the hype around this "Tableau destroyer" in recent months, I want to highlight some fundamental flaws in data connectivity and reports maintenance of Power BI, which the Product Team so far has turned down as "not in scope". In practice, though, this renders Power BI pretty useless for getting dara from any 3rd party products, in the cloud in particular.

This review reflects Power BI as of mid March 2017. I have gathered my knowledge from testing, community interaction and a dozen tickets with Power BI Pro Support. The focus lies on getting data via Web Services, much aligned with Microsoft’s «Cloud First» Strategy.

1) Power BI Online is in the cloud, but does not allow for HTTP calls. Power BI Desktop allows for HTTP calls, but only with static authentication parameters.
First of all, a distinction needs to be made between Power BI Online and Power BI Desktop. While Power BI Online is the "master" that ultimately allows you to share and publish your reports, user experience in design is diminished by HTML limitations (you may know from Word or Excel Online) and more importantly, data connectivity (Get Data) is limited to SQL Servers on Azure and about 20 to 30 plugins from 3rd party solutions at present. Take note that on Power BI Online, you cannot select or manage your Gateways, either.

This brings the attention to the Power BI Desktop client. Updated every one to two months, the Desktop client brings data connectors necessary to connect to a larger number of data sources.
With the Web connector, HTTP calls been configured, although with just static headers and parameters and Basic and Windows authentication only. Importantly, though, Power BI Desktop includes Microsoft Power Query, which you may know from Excel 2016 already. With M Scripts, you can script and customise in many ways and most interestingly, convert it into table form quickly. This is where Power Query shines. However, Power Query does not seem to call on methods for nonces and timestamps required in token based authentication (OAuth for example). (Should this be incorrect, please please let me know. I have been browsing the fora and nagging Support too long already.)
What’s really amusing here is that Microsoft Azure uses OAuth 2.0 themselves. So, you cannot run any reporting on Microsoft’s Azure AD or Resource Manager database for example, a notorious blackbox. Back to Powershell. (Power BI does not accept Powershell feeds.)
In short, while Power BI Online does not allow to get any data out of the web (except for those 20 to 30 plugins, mostly Microsoft Products), Power BI Desktop allows for Web calls, but only with static parameters and thus, basically with your user credentials.
That’s a big limitation in Data Connectivity.

2) With Power BI Online being the master, the HTTP calls cannot be scheduled or refreshed in the cloud.

Now that you have configured your HTTP call (with risky user credentials), you want to publish your report and have it refreshed on a scheduled basis, say every day.
Tough luck.
While you can publish your Report to Power BI Online and subsequently a broader audience, it’s a static image of your Desktop data. You cannot schedule a data refresh in Power BI Online (because there is no Web feature anyway) and you cannot even refresh the data manually as this requires republishing the Report anew.
You risk your management looking at outdated data whenever you forgot to republish your report and sneak the new URL into your dashboards and iframes.

3) The On-Premises Data Gateway is pretty useless for Web Services.
Yes, there is the On-Premises Data Gateway. Yes, you can configure Web Services in the gateway, although it’s pretty ironic to route web calls via on-premises infrastructure.
But did you ever try it? That is, you cannot specify any HTTP headers fort he calls at all, lest writing a Power Query script. And thus, we are back at authentication via Basic and Windows only and writing REST scripts in the data source for every single HTTP call because with no Headers and Body, all parameters need to be coded in the URI.
Will you do that?

At the end of the day, Power BI is Microsoft's long overdue acknowledgement that Excel and some Dynamics Reports do not cut it for Reporting purposes. Indeed, for reporting on SQL Server, Dynamics 365 (if you want to afford it), and Excel and Access databases stored in your OneDrive, Microsoft Power BI does a neat job.

However, as soon as you want to integrate with 3rd party systems or via web services in particular, Power BI presents so many limitations in authentication, Header and Body configuration, scripting, and scheduling that you need to configure an entire SQL Server environment (on Azure or On-Premises via feature poor Gateway) and write a SQL CRL interface or buy Azure Data Factory to get that data in.

For some pretty reports, do you really want to buy and customise all that BI infrastructure on Azure?

My advice to Microsoft: Work on Data Connectivity, especially in Power BI Online, rather than more visuals for those limited data sources. Your Microsoft clients will consider Power BI a given for the utter lack of reporting in Office 365, Azure, or Dynamics 365 (yes, pushing it there).
My advice to Users: If the connectors are not listed, look somewhere else. (And make sure it’s your use case that is listed. Power BI announced an Azure AD connector, but rather than reporting on Users, Groups, or Enterprise Apps, you can only see on a nice map where the last logins happened.)

Is it a Tableau destroyer? No. It’s a long overdue acknowledgement for necessary reporting with the potential of being a solid Business Intelligence solution ONCE focus comes to lie more on data.


Mit Google übersetzen
Prabhu S.

Simple and highly customizable

1. Dax query is highly reliable when comes to slice and dice the granular level data based on time trend.
2. Embedded report and dashboard in any kind of business applications easily and it becomes part of it.


Mit Google übersetzen
Michael K.
Branche: Tabak
Untern. Größe: 501-1.000 Mitarbeiter
Übersetzen auf: Deutsch
Übersetzen auf: Deutsch

Ugly numbers to pretty pictures

Wöchentlich für Mehr als 1 Jahr genutzt
Bewertet am 13.6.2020
Quelle der Bewertung: Capterra

Management loves it, I love developing with it but getting certain others to adopt it can be a bit of a challenge.

Vorteile

As the title says, it turns ugly numbers into pretty pictures. It is easy enough for a non-developer to use and turn a mess of data into an intelligent and understandable story.

Nachteile

It literally changes every three months. You just get used to it and with the next update a lot has changed. I don't really see this as a con though because this is more like a Christmas present waiting to see what they will have made better this go around.

Verteilung der Bewertung

Preis-Leistungs-Verhältnis
Bedienkomfort
Kundenbetreuung

Weiterempfehlungsquote: 10.0/10

Deepak F.
Branche: Computer-Software
Untern. Größe: 51-200 Mitarbeiter
Übersetzen auf: Deutsch
Übersetzen auf: Deutsch

The visualization and analytics product that is constantly evolving - for the better

Täglich für Mehr als 2 Jahre genutzt
Bewertet am 7.2.2020
Quelle der Bewertung: Capterra

With Power BI we identify patterns, issues and opportunities in sales, marketing, operations, supply chain, people management and finance data. The ways to look at the data and the drilling capabilities make this a wonderful tool

Vorteile

1. Improves with new releases every two weeks
2. Powerful insight management
3. Integration with MS products
4. Online forums and learning zones

Nachteile

1. Not as intuitive as packaged applications, but getting there
2. Not a good IDE for Python / R
3. Connectors to social media need to be improved

Verteilung der Bewertung

Preis-Leistungs-Verhältnis
Bedienkomfort

Weiterempfehlungsquote: 10.0/10

Dan S.
Branche: Personalwesen
Untern. Größe: 11-50 Mitarbeiter
Übersetzen auf: Deutsch
Übersetzen auf: Deutsch

The best gets better

Täglich für Mehr als 1 Jahr genutzt
Bewertet am 6.10.2020
Quelle der Bewertung: Capterra

It's easily the most feature rich overall. Other products like Tableau and Qlik have their advantages, but I'm hard pressed to find much fault with Power BI, other than the premium licenses being ridiculously expensive. The word is Microsoft is addressing that issue later in 2020/2021.

Vorteile

The features and ease of creating visualizations are top notch. Also integration with all other Microsoft products as well as pre-built connectors to many of the most popular software is hard to beat.

Nachteile

There are many features not available unless you pay for expensive premium capacity.

Verteilung der Bewertung

Preis-Leistungs-Verhältnis
Bedienkomfort
Kundenbetreuung

Weiterempfehlungsquote: 9.0/10

Verifizierter Rezensent
Branche: Unternehmensberatung
Untern. Größe: 201-500 Mitarbeiter
Übersetzen auf: Deutsch
Übersetzen auf: Deutsch

A pretty reporting tool for some (!) Microsoft Products, but pretty much useless outside of the Microsoft Landscape

Täglich für 6-12 Monate genutzt
Bewertet am 18.3.2017
Quelle der Bewertung: GetApp

In light of the hype around this "Tableau destroyer" in recent months, I want to highlight some fundamental flaws in data connectivity and reports maintenance of Power BI, which the Product Team so far has turned down as "not in scope". In practice, though, this renders Power BI pretty useless for getting dara from any 3rd party products, in the cloud in particular.

This review reflects Power BI as of mid March 2017. I have gathered my knowledge from testing, community interaction and a dozen tickets with Power BI Pro Support. The focus lies on getting data via Web Services, much aligned with Microsoft’s «Cloud First» Strategy.

1) Power BI Online is in the cloud, but does not allow for HTTP calls. Power BI Desktop allows for HTTP calls, but only with static authentication parameters.
First of all, a distinction needs to be made between Power BI Online and Power BI Desktop. While Power BI Online is the "master" that ultimately allows you to share and publish your reports, user experience in design is diminished by HTML limitations (you may know from Word or Excel Online) and more importantly, data connectivity (Get Data) is limited to SQL Servers on Azure and about 20 to 30 plugins from 3rd party solutions at present. Take note that on Power BI Online, you cannot select or manage your Gateways, either.

This brings the attention to the Power BI Desktop client. Updated every one to two months, the Desktop client brings data connectors necessary to connect to a larger number of data sources.
With the Web connector, HTTP calls been configured, although with just static headers and parameters and Basic and Windows authentication only. Importantly, though, Power BI Desktop includes Microsoft Power Query, which you may know from Excel 2016 already. With M Scripts, you can script and customise in many ways and most interestingly, convert it into table form quickly. This is where Power Query shines. However, Power Query does not seem to call on methods for nonces and timestamps required in token based authentication (OAuth for example). (Should this be incorrect, please please let me know. I have been browsing the fora and nagging Support too long already.)
What’s really amusing here is that Microsoft Azure uses OAuth 2.0 themselves. So, you cannot run any reporting on Microsoft’s Azure AD or Resource Manager database for example, a notorious blackbox. Back to Powershell. (Power BI does not accept Powershell feeds.)
In short, while Power BI Online does not allow to get any data out of the web (except for those 20 to 30 plugins, mostly Microsoft Products), Power BI Desktop allows for Web calls, but only with static parameters and thus, basically with your user credentials.
That’s a big limitation in Data Connectivity.

2) With Power BI Online being the master, the HTTP calls cannot be scheduled or refreshed in the cloud.

Now that you have configured your HTTP call (with risky user credentials), you want to publish your report and have it refreshed on a scheduled basis, say every day.
Tough luck.
While you can publish your Report to Power BI Online and subsequently a broader audience, it’s a static image of your Desktop data. You cannot schedule a data refresh in Power BI Online (because there is no Web feature anyway) and you cannot even refresh the data manually as this requires republishing the Report anew.
You risk your management looking at outdated data whenever you forgot to republish your report and sneak the new URL into your dashboards and iframes.

3) The On-Premises Data Gateway is pretty useless for Web Services.
Yes, there is the On-Premises Data Gateway. Yes, you can configure Web Services in the gateway, although it’s pretty ironic to route web calls via on-premises infrastructure.
But did you ever try it? That is, you cannot specify any HTTP headers fort he calls at all, lest writing a Power Query script. And thus, we are back at authentication via Basic and Windows only and writing REST scripts in the data source for every single HTTP call because with no Headers and Body, all parameters need to be coded in the URI.
Will you do that?

At the end of the day, Power BI is Microsoft's long overdue acknowledgement that Excel and some Dynamics Reports do not cut it for Reporting purposes. Indeed, for reporting on SQL Server, Dynamics 365 (if you want to afford it), and Excel and Access databases stored in your OneDrive, Microsoft Power BI does a neat job.

However, as soon as you want to integrate with 3rd party systems or via web services in particular, Power BI presents so many limitations in authentication, Header and Body configuration, scripting, and scheduling that you need to configure an entire SQL Server environment (on Azure or On-Premises via feature poor Gateway) and write a SQL CRL interface or buy Azure Data Factory to get that data in.

For some pretty reports, do you really want to buy and customise all that BI infrastructure on Azure?

My advice to Microsoft: Work on Data Connectivity, especially in Power BI Online, rather than more visuals for those limited data sources. Your Microsoft clients will consider Power BI a given for the utter lack of reporting in Office 365, Azure, or Dynamics 365 (yes, pushing it there).
My advice to Users: If the connectors are not listed, look somewhere else. (And make sure it’s your use case that is listed. Power BI announced an Azure AD connector, but rather than reporting on Users, Groups, or Enterprise Apps, you can only see on a nice map where the last logins happened.)

Is it a Tableau destroyer? No. It’s a long overdue acknowledgement for necessary reporting with the potential of being a solid Business Intelligence solution ONCE focus comes to lie more on data.

Vorteile

pretty visuals
Power Query
On-premises Data Gateway
responsible Pro Support

Nachteile

lack of data sources
pretty useless for 3rd Party Web Sources

Verteilung der Bewertung

Preis-Leistungs-Verhältnis
Bedienkomfort
Kundenbetreuung

Weiterempfehlungsquote: 2.0/10

Prabhu S.
Branche: Informationstechnologie & -dienste
Untern. Größe: 10.000+ Mitarbeiter
Übersetzen auf: Deutsch
Übersetzen auf: Deutsch

Simple and highly customizable

Täglich für Mehr als 2 Jahre genutzt
Bewertet am 8.8.2020
Quelle der Bewertung: Capterra

1. Dax query is highly reliable when comes to slice and dice the granular level data based on time trend.
2. Embedded report and dashboard in any kind of business applications easily and it becomes part of it.

Vorteile

1. Free desktop tool for development(Power BI Desktop) and simple installation process.
2. Almost, we can connect many source to fetch the data. Ex csv,web,excel,sql,odbc etc..,
3. Specialized ETL(Extract,transform,load) to clean the raw unstructured data into structured data with help of Power Query.
4. Powerful DAX query to customized measure and calculated column to get desirable business metrics and KPIs.
5. Top standard visuals, Custom visuals(visual market) and also we can create our own visuals using reactjs.
6. Publish in cloud(azure) to view report anywhere in the world with help Power BI service.
7. High availability and low latency to view report and dashboard with help of xVelocity engine.
8. Anyone can easily create basic charts with structured data.

Nachteile

1. Power BI Desktop consumes a huge amount of resource in system.
2. Service monitoring increases for larger report consumers.
3. While dealing with an enormous volume of data, constant optimization takes place.

Verteilung der Bewertung

Preis-Leistungs-Verhältnis
Bedienkomfort
Kundenbetreuung

Weiterempfehlungsquote: 9.0/10

Nutzerempfehlung
8,4/10
Basierend auf 765 Benutzerbewertungen
Vergleiche Nutzerempfehlungen mit Alternativen
Mit Alternativen vergleichen

Microsoft Power BI Preis

Microsoft Power BI Preis

Beginnt ab
9,99 $/Monat
Gratis Testen
Kostenlos
Abonnement
Preis-Leistungs-Verhältnis
Preis-Leistungs-Verhältnis
4,4/5
Basierend auf 765 Benutzerbewertungen
Vergleiche das Preis-Leistungs-Verhältnis mit Alternativen
Mit Alternativen vergleichen

Microsoft Power BI Funktionen

Microsoft Power BI Funktionen

API
Ad-hoc-Berichterstattung
Aktivitäts-Dashboard
Anpassbare Berichterstellung
Berichterstattung und Statistik
Business Intelligence
Dashboard-Erstellung
Daten-Import / -Export
Datenfilterung
Datenvisualisierung
Diagramm-Erstellung
Echtzeit-Analytik
Echtzeit-Daten
Geschäftsanalysen
Integration von Dritten
Mehrfache Datenquellen
Prädiktive Analytik
Visuelle Analytik
Werkzeuge zur Zusammenarbeit
Überwachung
Funktionen
4,4/5
Basierend auf 765 Benutzerbewertungen
Vergleiche Funktionen mit Alternativen
Mit Alternativen vergleichen

Kategorien

Zusätzliche Informationen für Microsoft Power BI

Zusätzliche Informationen für Microsoft Power BI

Schlüssel-Features von Microsoft Power BI

  • Daten unter Verwendung natürlicher Sprachbefragung abrufen
  • Entdecken von aktuellen Analysen von BI-Daten in Echtzeit
  • Erhalte datengesteuerte Benachrichtigungen für mobile Einblicke
  • Erstellen von Live-Datenmetrik-Dashboards in Echtzeit
  • Freigabe von Live-Berichten und Dashboards
  • Interaktive Berichte mehrerer Autoren dank Power BI-Desktop
  • Teile Berichte mit Kollegen und Benutzern mithilfe des Power BI Service
  • Transformiere Unternehmensdaten in umfassende grafische Darstellungen
  • Umfassende grafische Darstellung von komplexen BI-Daten
  • Verbindung, Zugang und Vereinheitlichung von Daten aus verschiedenen Quellen
  • Vollständige BI-Tool-Suite zur Datenvisualisierung und Berichterstellung

Microsoft Power BI Häufig gestellte Fragen

Microsoft Power BI Häufig gestellte Fragen

Weiter unter folgen häufig gestellte Fragen über Microsoft Power BI.

F. Welche Preispläne bietet Microsoft Power BI an?

Microsoft Power BI bietet folgende Kostenpläne an:

Beginnt ab: 9,99 $/Monat

Preismodell: Kostenlos, Abonnement

Gratis Testen: Nicht verfügbar

F. Was sind die Hauptfunktionen von Microsoft Power BI?

Microsoft Power BI bietet die folgenden Funktionen:

  • Interaktive Berichte mehrerer Autoren dank Power BI-Desktop
  • Verbindung, Zugang und Vereinheitlichung von Daten aus verschiedenen Quellen
  • Erstellen von Live-Datenmetrik-Dashboards in Echtzeit
  • Entdecken von aktuellen Analysen von BI-Daten in Echtzeit
  • Vollständige BI-Tool-Suite zur Datenvisualisierung und Berichterstellung
  • Daten unter Verwendung natürlicher Sprachbefragung abrufen
  • Erhalte datengesteuerte Benachrichtigungen für mobile Einblicke
  • Freigabe von Live-Berichten und Dashboards
  • Teile Berichte mit Kollegen und Benutzern mithilfe des Power BI Service
  • Transformiere Unternehmensdaten in umfassende grafische Darstellungen
  • Umfassende grafische Darstellung von komplexen BI-Daten

F. Wer sind die typischen Nutzer von Microsoft Power BI?

Microsoft Power BI hat die folgenden typischen Kunden:

Großunternehmen, Mittlere Unternehmen

F: Welche Sprachen werden von Microsoft Power BI unterstützt?

Microsoft Power BI unterstützt die folgenden Sprachen:

Arabisch, Chinesisch (traditionell), Chinesisch (vereinfacht), Deutsch, Dänisch, Englisch, Finnisch, Französisch, Hebräisch, Indonesisch, Irisch, Italienisch, Japanisch, Koreanisch, Niederländisch, Norwegisch, Polnisch, Portugiesisch, Russisch, Schwedisch, Spanisch, Taiwanisch, Thai, Tschechisch, Türkisch, Ukrainisch, Ungarisch

F. Welche Preispläne bietet Microsoft Power BI an?

Microsoft Power BI hat folgende Preismodelle:

Kostenlos, Abonnement

F. Unterstützt Microsoft Power BI mobile Geräte?

Microsoft Power BI unterstützt die folgenden Geräte:

Android, iPhone, iPad

F. Mit welchen anderen Applikationen integriert Microsoft Power BI?

Microsoft Power BI kann in folgende Anwendungen integriert werden:

Insightly, JustFoodERP, Meisterplan, Microsoft Project, Microsoft Teams, OneSoft Connect, Pro-Sapien, Projectplace, Smartsheet, Tagetik

F. Welche Varianten der Kundenbetreuung bietet Microsoft Power BI an?

Microsoft Power BI bietet folgende Optionen für Kundensupport:

Online-Support, Häufig gestellte Fragen, Wissensdatenbank, Forum, Video-Anleitungen