Microsoft Power BI

Visualização e geração de relatórios de BI para desktop, Internet ou dispositivos móveis

4,5 /5 (755 avaliações) Escreva uma avaliação!

Resumo do Microsoft Power BI

O que é o Microsoft Power BI?

O Microsoft Power BI é um conjunto de ferramentas de análise para analisar dados empresariais e compartilhar informações por meio de visualizações avançadas. Os painéis personalizáveis e prontos unificam métricas importantes em visualizações únicas, mostrando atualizações em tempo real para cada dispositivo. O serviço centralizado do Power BI baseado na Internet faz interface com os gateways do Power BI para conectar e unificar dados organizacionais, enquanto o Power BI Desktop para Windows fornece unificação de dados locais e recursos de criação de relatórios. Os painéis em tempo real oferecem uma visualização instantânea em 360° da integridade dos negócios, aproveitando 59 conexões prontas para uso em aplicativos ou serviços como Salesforce, Google Analytics, Azure, Facebook, Github, QuickBooks Online, Twilio e Zendesk. O Power BI reúne todos esses dados, onde quer que estejam, formando uma imagem completa das principais métricas que podem ser consultadas usando linguagem natural.

Com o Power BI Desktop, os usuários podem criar relatórios usando ferramentas intuitivas de arrastar e soltar e compartilhar entre colegas por meio do Power BI Service online. Integrando-se ao mecanismo de consulta estabelecido pela Microsoft, às tecnologias de modelagem e visualização de dados, o Power BI Desktop conecta, molda e relata para centralizar um processo tipicamente desarticulado de geração de relatórios. Salvando no formato .pbix, esses arquivos de relatórios podem ser compartilhados manualmente como qualquer outro ou enviados para o serviço compartilhado. Além disso, essa possibilidade de manter todos os usuários informados o tempo todo se estende a um conjunto de suporte móvel otimizado. O Power BI Mobile mantém a conectividade remota consistente em aplicativos nativos para dispositivos Windows Mobile, iOS e Android, adicionando operação intuitiva baseada em gestos. Os painéis em tempo real podem ser visualizados rapidamente, juntamente com os recursos completos de compartilhamento de relatórios e alertas baseados em dados.

Resumo do Microsoft Power BI

Preços

A partir de
US$ 9,99/mês

Opções de preços

Teste Grátis
Gratuito
Assinatura
Relação qualidade/preço

Recursos do Microsoft Power BI

Dispositivos
Porte da empresa
P M G
Mercados
Estados Unidos, Canadá, Reino Unido, Austrália, China e outros 5, Índia, Japão, Alemanha, Brasil, México
Idiomas
Alemão, Checo, Chinês (simplificado), Chinês (tradicional), Coreano e outros 22, Danês, Espanhol, Filandês, Francês, Hebreu, Holandês, Húngaro, Indonésio, Inglês, Irlandês, Italiano, Japonês, Norueguês, Polonês, Português, Russo, Sueco, Tailandês, Taiwanês, Turco, Ucraniano, Árabe

Mídias

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
Microsoft Power BI - Vídeo Microsoft Power BI - Vídeo Microsoft Power BI - Vídeo Captura de tela do Microsoft Power BI: Microsoft Power BI Desktop shown on Thinkpad Captura de tela do Microsoft Power BI: Microsoft Power BI Executive Metrics Dashboard Captura de tela do Microsoft Power BI: Microsoft Power BI Mobile for iPad Captura de tela do Microsoft Power BI: Microsoft Power BI Query Editor Captura de tela do Microsoft Power BI: Microsoft Power BI reporting visualizations Captura de tela do Microsoft Power BI: Microsoft Power BI shown on Microsoft Surface Captura de tela do Microsoft Power BI: Power BI Desktop Welcome screen

Microsoft Power BI - Avaliações

Microsoft Power BI - Avaliações

Classificação geral
4,5
/
5
Excelente
418

Muito bom
289

Regular
39

Ruim
7

Péssimo
2

Relação qualidade/preço
4,4
Recursos
4,4
Praticidade
4
Suporte ao cliente
4,1
94% dos usuários recomendam este app
Bruna P.

Futuro

Ótima, um dos melhores programas já desenvolvidos ate hoje.


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.


Traduzir com Google
Jerry A.

Very robust, though a little overwhelming

We're moving from having staff creating Excel reports or Access database reports to having Power BI do it all for us. We spend some time cleaning up the user's data, streamlining how they enter it (and where - we still use Access, some SQL, some Sharepoint), and Power BI does the rest after that. Our staff loves that they no longer have to manually create reports, and they love the way Power BI looks for them. We are enjoying it overall.


Traduzir com Google
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.


Traduzir com Google
Avaliador Verificado

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.


Traduzir com Google
Bruna P.
Setor: Editoras
Porte da empresa: 201-500 funcionários

Futuro

Usado Diariamente durante 6 a 12 meses
Avaliado em 19/08/2020
Fonte da avaliação: Capterra

Ótima, um dos melhores programas já desenvolvidos ate hoje.

Vantagens

Temos todas as funcionalidade do Excel melhoradas podemos resolver tudo com mais agilidade e rapidez.

Desvantagens

Acredito que o custo beneficio ainda não esta dos melhores pois e muito caro e tem que se pagar por ano.

Detalhamento da qualificação

Relação qualidade/preço
Praticidade
Suporte ao cliente

Probabilidade de recomendação: 9.0/10

Michael K.
Setor: Tabaco
Porte da empresa: 501-1.000 funcionários
Traduzido para o Português
Traduzido para o Português

Ugly numbers to pretty pictures

Usado Semanal durante Mais de um ano
Avaliado em 13/06/2020
Fonte da avaliação: Capterra

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

Vantagens

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.

Desvantagens

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.

Detalhamento da qualificação

Relação qualidade/preço
Praticidade
Suporte ao cliente

Probabilidade de recomendação: 10.0/10

Jerry A.
Setor: Gestão de organizações sem fins lucrativos
Porte da empresa: 201-500 funcionários
Traduzido para o Português
Traduzido para o Português

Very robust, though a little overwhelming

Usado Diariamente durante Mais de um ano
Avaliado em 10/12/2019
Fonte da avaliação: Capterra

We're moving from having staff creating Excel reports or Access database reports to having Power BI do it all for us. We spend some time cleaning up the user's data, streamlining how they enter it (and where - we still use Access, some SQL, some Sharepoint), and Power BI does the rest after that. Our staff loves that they no longer have to manually create reports, and they love the way Power BI looks for them. We are enjoying it overall.

Vantagens

The dashboard creation is amazing. Give it a data source, design how you want to see your data, and it shows it to you. I enjoy creating dashboards for our different departments. And once our staff sees the reports and dashboards they get from this, vs how they used to get it in an Excel spreadsheet or an Access Report, they are hooked.

Desvantagens

Overwhelming in the back end. Sometimes you just cannot get the data to display the way you want. There are so many options, features, methods. It gets overwhelming. My biggest gripe is that the back end is not as user friendly as other programs. And, comparing it to something that one of my users would create in Excel, it's difficult for me to get the exact data reported that they want. I have to figure out how to display it, and because the Power Bi is just so robust, it's a little overwhelming in that respect.

Detalhamento da qualificação

Relação qualidade/preço
Praticidade

Probabilidade de recomendação: 9.0/10

Dan S.
Setor: Recursos Humanos
Porte da empresa: 11-50 funcionários
Traduzido para o Português
Traduzido para o Português

The best gets better

Usado Diariamente durante Mais de um ano
Avaliado em 06/10/2020
Fonte da avaliação: 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.

Vantagens

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.

Desvantagens

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

Detalhamento da qualificação

Relação qualidade/preço
Praticidade
Suporte ao cliente

Probabilidade de recomendação: 9.0/10

Avaliador Verificado
Setor: Consultoria de gestão
Porte da empresa: 201-500 funcionários
Traduzido para o Português
Traduzido para o Português

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

Usado Diariamente durante 6 a 12 meses
Avaliado em 18/03/2017
Fonte da avaliação: 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.

Vantagens

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

Desvantagens

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

Detalhamento da qualificação

Relação qualidade/preço
Praticidade
Suporte ao cliente

Probabilidade de recomendação: 2.0/10

Recomendação do usuário
8,4/10
Baseado em 755 usuários
Compare as alternativas por recomendação dos usuários
Compare com alternativas

Preço do Microsoft Power BI

Preço do Microsoft Power BI

A partir de
US$ 9,99/mês
Teste Grátis
Gratuito
Assinatura
Relação qualidade/preço
Relação qualidade/preço
4,4/5
Baseado em 755 usuários
Compare as alternativas por relação qualidade/preço
Compare com alternativas

Recursos do Microsoft Power BI

Recursos do Microsoft Power BI

API
Análise de dados em tempo real
Análise de dados preditiva
Análise de dados visual
Análise de tendências
Business Intelligence
Criação de diagramas
Criação de painel
Criação de relatórios personalizável
Dados em tempo real
Ferramentas de colaboração
Filtragem de dados
Geração pontual de relatórios
Importação/exportação de dados
Integração de terceiros
Monitoramento
Múltiplas fontes de dados
Painel de atividades
Relatórios e estatística
Visualização de dados
Recursos
4,4/5
Baseado em 755 usuários
Compare as alternativas por avaliações dos recursos
Compare com alternativas

Categorias

Perguntas frequentes sobre o Microsoft Power BI

Perguntas frequentes sobre o Microsoft Power BI

Abaixo estão algumas perguntas frequentes sobre o Microsoft Power BI.

P: Que tipo de planos o Microsoft Power BI oferece?

O Microsoft Power BI oferece os seguintes planos de pagamento:

A partir de: US$ 9,99/mês

Modelo de preços: Gratuito, Assinatura

Teste Grátis: Não disponível

P: Quais são os principais recursos do Microsoft Power BI?

Não temos informações sobre os recursos do Microsoft Power BI.

P: Quem costuma usar o Microsoft Power BI?

Os clientes habituais do Microsoft Power BI são:

Grandes empresas, Empresas de médio porte

P: Em que idioma o Microsoft Power BI está?

O Microsoft Power BI está nos seguintes idiomas:

Alemão, Checo, Chinês (simplificado), Chinês (tradicional), Coreano, Danês, Espanhol, Filandês, Francês, Hebreu, Holandês, Húngaro, Indonésio, Inglês, Irlandês, Italiano, Japonês, Norueguês, Polonês, Português, Russo, Sueco, Tailandês, Taiwanês, Turco, Ucraniano, Árabe

P: Que tipo de planos o Microsoft Power BI oferece?

O Microsoft Power BI tem os seguintes planos de preços:

Gratuito, Assinatura

P: O Microsoft Power BI é compatível com disponíveis móveis?

O Microsoft Power BI é compatível com os seguintes dispositivos:

Android, iPhone, iPad

P: O Microsoft Power BI se integra com quais outros aplicativos?

O Microsoft Power BI se integra com os seguintes aplicativos:

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

P: Que nível de suporte o Microsoft Power BI oferece?

O Microsoft Power BI oferece as seguintes opções de suporte:

Suporte online, FAQs, Base de conhecimento, Fórum, Tutoriais em vídeo