{"id":16616,"date":"2025-04-28T14:25:45","date_gmt":"2025-04-28T17:25:45","guid":{"rendered":"https:\/\/kb.elipse.com.br\/?p=16616"},"modified":"2025-04-28T15:14:53","modified_gmt":"2025-04-28T18:14:53","slug":"visualizando-dados-do-epm-no-power-bi","status":"publish","type":"post","link":"https:\/\/kb.elipse.com.br\/en\/visualizando-dados-do-epm-no-power-bi\/","title":{"rendered":"Visualizando dados do EPM no Power BI."},"content":{"rendered":"<p class=\"\" data-start=\"190\" data-end=\"481\">A escolha da ferramenta de visualiza\u00e7\u00e3o e an\u00e1lise de dados depende do <strong data-start=\"260\" data-end=\"295\">perfil do usu\u00e1rio da informa\u00e7\u00e3o<\/strong>. Para usu\u00e1rios que necessitam de dashboards e relat\u00f3rios interativos, uma solu\u00e7\u00e3o comum \u00e9 integrar o <strong data-start=\"397\" data-end=\"411\">EPM<\/strong> com o <strong data-start=\"418\" data-end=\"430\">Power BI<\/strong>, ferramenta de Business Intelligence da Microsoft.<\/p>\n<p class=\"\" data-start=\"516\" data-end=\"817\">O Power BI \u00e9 tradicionalmente utilizado para an\u00e1lise de dados transacionais (compras, vendas, atendimento, etc.), onde os dados s\u00e3o carregados uma \u00fanica vez para consultas constantes.<br data-start=\"699\" data-end=\"702\" \/>J\u00e1 o <strong data-start=\"707\" data-end=\"714\">EPM<\/strong> armazena <strong data-start=\"724\" data-end=\"743\">dados temporais<\/strong>, que representam a evolu\u00e7\u00e3o dos processos ao longo do tempo. Esses dados:<\/p>\n<ul data-start=\"819\" data-end=\"1008\">\n<li class=\"\" data-start=\"819\" data-end=\"912\">\n<p class=\"\" data-start=\"821\" data-end=\"912\">S\u00e3o registrados de acordo com o comportamento dos processos, n\u00e3o seguindo intervalos fixos.<\/p>\n<\/li>\n<li class=\"\" data-start=\"913\" data-end=\"1008\">\n<p class=\"\" data-start=\"915\" data-end=\"1008\">Est\u00e3o armazenados em formato propriet\u00e1rio, e n\u00e3o em um banco de dados relacional tradicional.<\/p>\n<\/li>\n<\/ul>\n<p class=\"\" data-start=\"1010\" data-end=\"1169\">Portanto, para utilizar esses dados no Power BI, \u00e9 necess\u00e1rio um processo de consulta, agrega\u00e7\u00e3o e tratamento para adapta\u00e7\u00e3o ao formato aceito pela ferramenta.<\/p>\n<h2 class=\"\" data-start=\"1176\" data-end=\"1210\">Como conectar o Power BI ao EPM<\/h2>\n<p class=\"\" data-start=\"1212\" data-end=\"1320\">A conex\u00e3o entre o Power BI e o EPM \u00e9 realizada atrav\u00e9s do <strong data-start=\"1270\" data-end=\"1292\">EPM OLEDB Provider<\/strong>. Veja os passos principais:<\/p>\n<ol data-start=\"1322\" data-end=\"1903\">\n<li class=\"\" data-start=\"1322\" data-end=\"1427\">\n<p class=\"\" data-start=\"1325\" data-end=\"1359\"><strong data-start=\"1325\" data-end=\"1358\">Instalar o <a href=\"https:\/\/www.elipse.com.br\/downloads\/?cat=65&#038;key=&#038;language=ptbr\">EPM OLEDB Provider<\/a><\/strong>:<\/p>\n<ul data-start=\"1363\" data-end=\"1427\">\n<li class=\"\" data-start=\"1363\" data-end=\"1427\">\n<p class=\"\" data-start=\"1365\" data-end=\"1427\">Deve ser instalado no computador que ir\u00e1 acessar o EPM Server.<\/p>\n<\/li>\n<\/ul>\n<\/li>\n<li class=\"\" data-start=\"1429\" data-end=\"1657\">\n<p class=\"\" data-start=\"1432\" data-end=\"1456\"><strong data-start=\"1432\" data-end=\"1455\">Instalar o Power BI<\/strong>:<\/p>\n<ul data-start=\"1460\" data-end=\"1657\">\n<li class=\"\" data-start=\"1460\" data-end=\"1518\">\n<p class=\"\" data-start=\"1462\" data-end=\"1518\">O <strong data-start=\"1464\" data-end=\"1484\">Power BI Desktop<\/strong> pode ser utilizado gratuitamente.<\/p>\n<\/li>\n<li class=\"\" data-start=\"1522\" data-end=\"1657\">\n<p class=\"\" data-start=\"1524\" data-end=\"1657\">Alternativamente, vers\u00f5es pagas como <strong data-start=\"1561\" data-end=\"1577\">Power BI Pro<\/strong> ou o <strong data-start=\"1583\" data-end=\"1603\">Microsoft Fabric<\/strong> podem ser utilizadas para funcionalidades adicionais.<\/p>\n<\/li>\n<\/ul>\n<\/li>\n<li class=\"\" data-start=\"1659\" data-end=\"1903\">\n<p class=\"\" data-start=\"1662\" data-end=\"1687\"><strong data-start=\"1662\" data-end=\"1686\">Configurar a conex\u00e3o<\/strong>:<\/p>\n<ul data-start=\"1691\" data-end=\"1903\">\n<li class=\"\" data-start=\"1691\" data-end=\"1817\">\n<p class=\"\" data-start=\"1693\" data-end=\"1817\">Ap\u00f3s instalar o EPM OLEDB Provider, utilize o <strong data-start=\"1739\" data-end=\"1773\">EPM OLE DB Data Source Manager<\/strong> para configurar a conex\u00e3o com o EPM Server.<\/p>\n<\/li>\n<li class=\"\" data-start=\"1821\" data-end=\"1903\">\n<p class=\"\" data-start=\"1823\" data-end=\"1903\">Mais detalhes est\u00e3o dispon\u00edveis no <span data-olk-copy-source=\"MessageBody\"><a href=\"https:\/\/docs.elipse.com.br\/documents\/pt-br\/epm\/latest\/manual\/oledb\/index.html?oledb_config.html\">Manual do Usu\u00e1rio do EPM OLE DB Provider<\/a><\/span>.<\/p>\n<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<h2 class=\"\" data-start=\"1910\" data-end=\"1924\">Observa\u00e7\u00f5es<\/h2>\n<ul data-start=\"1926\" data-end=\"2128\">\n<li class=\"\" data-start=\"1926\" data-end=\"1993\">\n<p class=\"\" data-start=\"1928\" data-end=\"1993\">Na vers\u00e3o gratuita, a publica\u00e7\u00e3o de dashboards online \u00e9 limitada.<\/p>\n<\/li>\n<li class=\"\" data-start=\"1994\" data-end=\"2128\">\n<p class=\"\" data-start=\"1996\" data-end=\"2128\">Para automa\u00e7\u00f5es e compartilhamento em larga escala, recomenda-se o uso da vers\u00e3o Pro ou ambientes corporativos com Microsoft Fabric.<\/p>\n<\/li>\n<\/ul>\n<figure id=\"attachment_16618\" style=\"width: 786px\"  class=\"wp-caption aligncenter\"><img loading=\"lazy\" class=\"wp-image-16618 size-full\" src=\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2024\/11\/16616\/OLEDBMngr.png\" alt=\"EPM OLE DB Data Source Manager\" width=\"786\" height=\"443\" srcset=\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2024\/11\/16616\/OLEDBMngr.png 786w, https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2024\/11\/16616\/OLEDBMngr-300x169.png 300w, https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2024\/11\/16616\/OLEDBMngr-768x433.png 768w\" sizes=\"(max-width: 786px) 100vw, 786px\" \/><figcaption class=\"wp-caption-text\">Exemplo de configura\u00e7\u00e3o de conex\u00e3o com o EPM Server via OLEDB Provider<\/figcaption><\/figure>\n<h2 class=\"\" data-start=\"371\" data-end=\"408\">Configurando a conex\u00e3o no Power BI<\/h2>\n<p class=\"\" data-start=\"410\" data-end=\"526\">Com o <strong data-start=\"416\" data-end=\"438\">EPM OLEDB Provider<\/strong> instalado e configurado, siga os passos abaixo para consultar dados do EPM no Power BI:<\/p>\n<ol data-start=\"528\" data-end=\"1077\">\n<li class=\"\" data-start=\"528\" data-end=\"653\">\n<p class=\"\" data-start=\"531\" data-end=\"567\"><strong data-start=\"531\" data-end=\"566\">Obter dados de uma fonte OLE DB<\/strong>:<\/p>\n<ul data-start=\"571\" data-end=\"653\">\n<li class=\"\" data-start=\"571\" data-end=\"653\">\n<p class=\"\" data-start=\"573\" data-end=\"653\">No Power BI Desktop, clique em <strong data-start=\"604\" data-end=\"619\">Obter dados<\/strong> \u2192 <strong data-start=\"622\" data-end=\"639\">Outras fontes<\/strong> \u2192 <strong data-start=\"642\" data-end=\"652\">OLE DB<\/strong>.<\/p>\n<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p><img loading=\"lazy\" class=\"wp-image-16619 size-full aligncenter\" src=\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2024\/11\/16616\/Step1.png\" alt=\"\" width=\"673\" height=\"660\" srcset=\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2024\/11\/16616\/Step1.png 673w, https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2024\/11\/16616\/Step1-300x294.png 300w\" sizes=\"(max-width: 673px) 100vw, 673px\" \/><\/p>\n<ol style=\"list-style-type: decimal;\" start=\"2\">\n<li>\n<p class=\"\" data-start=\"658\" data-end=\"684\"><strong data-start=\"658\" data-end=\"683\">Selecionar o provedor<\/strong>:<\/p>\n<ul data-start=\"688\" data-end=\"745\">\n<li class=\"\" data-start=\"688\" data-end=\"745\">\n<p class=\"\" data-start=\"690\" data-end=\"745\">Escolha <strong data-start=\"698\" data-end=\"720\">EPM OLEDB Provider<\/strong> e clique em <strong data-start=\"733\" data-end=\"744\">Avan\u00e7ar<\/strong>.<\/p>\n<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-16620 size-full\" src=\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2024\/11\/16616\/Step2.png\" alt=\"\" width=\"699\" height=\"466\" srcset=\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2024\/11\/16616\/Step2.png 699w, https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2024\/11\/16616\/Step2-300x200.png 300w, https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2024\/11\/16616\/Step2-272x182.png 272w\" sizes=\"(max-width: 699px) 100vw, 699px\" \/><\/p>\n<ol style=\"list-style-type: decimal;\" start=\"3\">\n<li style=\"list-style-type: none;\">\n<ol style=\"list-style-type: decimal;\" start=\"3\">\n<li>\n<p class=\"\" data-start=\"750\" data-end=\"773\"><strong data-start=\"750\" data-end=\"772\">Informar a conex\u00e3o<\/strong>:<\/p>\n<ul data-start=\"777\" data-end=\"934\">\n<li class=\"\" data-start=\"777\" data-end=\"886\">\n<p class=\"\" data-start=\"779\" data-end=\"886\">No campo <strong data-start=\"788\" data-end=\"807\">Nome da Conex\u00e3o<\/strong>, selecione ou digite o nome configurado no <strong data-start=\"851\" data-end=\"885\">EPM OLE DB Data Source Manager<\/strong>.<\/p>\n<\/li>\n<li class=\"\" data-start=\"890\" data-end=\"934\">\n<p class=\"\" data-start=\"892\" data-end=\"934\">Clique em <strong data-start=\"902\" data-end=\"920\">Testar conex\u00e3o<\/strong> para validar.<\/p>\n<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-16621 size-full\" src=\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2024\/11\/16616\/Step3.png\" alt=\"\" width=\"698\" height=\"465\" srcset=\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2024\/11\/16616\/Step3.png 698w, https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2024\/11\/16616\/Step3-300x200.png 300w, https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2024\/11\/16616\/Step3-272x182.png 272w\" sizes=\"(max-width: 698px) 100vw, 698px\" \/><\/p>\n<ol style=\"list-style-type: decimal;\" start=\"4\">\n<li>\n<p class=\"\" data-start=\"939\" data-end=\"976\"><strong data-start=\"939\" data-end=\"975\">Configurar e carregar a consulta<\/strong>:<\/p>\n<ul data-start=\"980\" data-end=\"1077\">\n<li class=\"\" data-start=\"980\" data-end=\"1077\">\n<p class=\"\" data-start=\"982\" data-end=\"1077\">Defina a consulta conforme a necessidade e clique em <strong data-start=\"1035\" data-end=\"1041\">OK<\/strong> para carregar os dados no Power BI.<\/p>\n<\/li>\n<\/ul>\n<p>Para mais informa\u00e7\u00f5es sobre as consultas dispon\u00edveis a partir do EPM OLE DB Provider, acesse <a href=\"https:\/\/docs.elipse.com.br\/documents\/pt-br\/epm\/latest\/manual\/oledb\/index.html?oledb_usage_function_query.html\">Manual do Usu\u00e1rio do EPM OLE DB Provider<\/a>.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-16622 size-full\" src=\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2024\/11\/16616\/Step4.png\" alt=\"\" width=\"699\" height=\"441\" srcset=\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2024\/11\/16616\/Step4.png 699w, https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2024\/11\/16616\/Step4-300x189.png 300w\" sizes=\"(max-width: 699px) 100vw, 699px\" \/><\/p>\n<p>A partir desses passos, os dados do EPM estar\u00e3o dispon\u00edveis para uso no Power BI localmente.\u00a0Entretanto, este relat\u00f3rio tamb\u00e9m pode ser publicado no Power BI para visualiza\u00e7\u00e3o online.<\/p>\n<h2 class=\"\" data-start=\"1203\" data-end=\"1248\">Publicando e atualizando relat\u00f3rios online<\/h2>\n<p class=\"\" data-start=\"1250\" data-end=\"1273\">Ap\u00f3s carregar os dados:<\/p>\n<ul data-start=\"1275\" data-end=\"1474\">\n<li class=\"\" data-start=\"1275\" data-end=\"1338\">\n<p class=\"\" data-start=\"1277\" data-end=\"1338\">\u00c9 poss\u00edvel publicar o relat\u00f3rio no Power BI Service (online).<\/p>\n<\/li>\n<li class=\"\" data-start=\"1339\" data-end=\"1474\">\n<p class=\"\" data-start=\"1341\" data-end=\"1474\">Altera\u00e7\u00f5es nos per\u00edodos consultados (ex.: per\u00edodos extensos) exigem a atualiza\u00e7\u00e3o manual no Power BI Desktop e novo envio ao servi\u00e7o.<\/p>\n<\/li>\n<\/ul>\n<h2 class=\"\" data-start=\"1481\" data-end=\"1532\">Automatizando a atualiza\u00e7\u00e3o com Power BI Gateway<\/h2>\n<p class=\"\" data-start=\"1534\" data-end=\"1579\">Para facilitar a atualiza\u00e7\u00e3o de dados online:<\/p>\n<p class=\"\" data-start=\"1584\" data-end=\"1647\"><strong data-start=\"1584\" data-end=\"1614\">1. Instale o <a href=\"https:\/\/www.microsoft.com\/pt-br\/power-platform\/products\/power-bi\/gateway?msockid=2727a03c18a26aa53622b38c19136bda\">Power BI Gateway<\/a><\/strong> no servidor de origem dos dados.<\/p>\n<p class=\"\" data-start=\"1651\" data-end=\"1676\"><strong data-start=\"1651\" data-end=\"1675\">2. Configure par\u00e2metros<\/strong>:<\/p>\n<ul data-start=\"1680\" data-end=\"1832\">\n<li class=\"\" data-start=\"1680\" data-end=\"1773\">\n<p class=\"\" data-start=\"1682\" data-end=\"1773\">No Power BI Desktop, crie par\u00e2metros <code data-start=\"1719\" data-end=\"1731\">RangeStart<\/code> e <code data-start=\"1734\" data-end=\"1744\">RangeEnd<\/code> em <strong data-start=\"1748\" data-end=\"1772\">Gerenciar par\u00e2metros<\/strong>.<\/p>\n<\/li>\n<li class=\"\" data-start=\"1777\" data-end=\"1828\">\n<p class=\"\" data-start=\"1779\" data-end=\"1828\">Utilize esses par\u00e2metros para filtrar a consulta.<\/p>\n<\/li>\n<\/ul>\n<p class=\"\" data-start=\"1836\" data-end=\"1891\"><strong data-start=\"1836\" data-end=\"1847\">Exemplo<\/strong>: Filtro din\u00e2mico com RangeStart e RangeEnd.<\/p>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_16646\" style=\"width: 598px\"  class=\"wp-caption aligncenter\"><img loading=\"lazy\" class=\"wp-image-16646 size-full\" src=\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2024\/12\/16616\/ParametrosPBI.png\" alt=\"\" width=\"598\" height=\"647\" srcset=\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2024\/12\/16616\/ParametrosPBI.png 598w, https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2024\/12\/16616\/ParametrosPBI-277x300.png 277w\" sizes=\"(max-width: 598px) 100vw, 598px\" \/><figcaption class=\"wp-caption-text\">Par\u00e2metros de consulta Power BI Destkop<\/figcaption><\/figure>\n<figure id=\"attachment_16647\" style=\"width: 1274px\"  class=\"wp-caption aligncenter\"><img loading=\"lazy\" class=\"size-full wp-image-16647\" src=\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2024\/12\/16616\/ConsultaComParametrosPBI.png\" alt=\"\" width=\"1274\" height=\"140\" srcset=\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2024\/12\/16616\/ConsultaComParametrosPBI.png 1274w, https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2024\/12\/16616\/ConsultaComParametrosPBI-300x33.png 300w, https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2024\/12\/16616\/ConsultaComParametrosPBI-1024x113.png 1024w, https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2024\/12\/16616\/ConsultaComParametrosPBI-768x84.png 768w\" sizes=\"(max-width: 1274px) 100vw, 1274px\" \/><figcaption class=\"wp-caption-text\">Exemplo de consulta com par\u00e2metros de filtro<\/figcaption><\/figure>\n<p class=\"\" data-start=\"1896\" data-end=\"1935\"><strong data-start=\"1896\" data-end=\"1934\">3. Configurar atualiza\u00e7\u00e3o incremental<\/strong>:<\/p>\n<ul data-start=\"1939\" data-end=\"2063\">\n<li class=\"\" data-start=\"1939\" data-end=\"2010\">\n<p class=\"\" data-start=\"1941\" data-end=\"2010\">Clique com o bot\u00e3o direito na consulta \u2192 <strong data-start=\"1982\" data-end=\"2009\">Atualiza\u00e7\u00e3o incremental<\/strong>.<\/p>\n<\/li>\n<li class=\"\" data-start=\"2014\" data-end=\"2063\">\n<p class=\"\" data-start=\"2016\" data-end=\"2063\">Defina o per\u00edodo e a estrat\u00e9gia de atualiza\u00e7\u00e3o.<\/p>\n<\/li>\n<\/ul>\n<figure id=\"attachment_16648\" style=\"width: 616px\"  class=\"wp-caption aligncenter\"><img loading=\"lazy\" class=\"size-full wp-image-16648\" src=\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2024\/12\/16616\/AtualizacaoIncrementalPBI.png\" alt=\"\" width=\"616\" height=\"702\" srcset=\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2024\/12\/16616\/AtualizacaoIncrementalPBI.png 616w, https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2024\/12\/16616\/AtualizacaoIncrementalPBI-263x300.png 263w\" sizes=\"(max-width: 616px) 100vw, 616px\" \/><figcaption class=\"wp-caption-text\">Exemplo de configura\u00e7\u00e3o para atualiza\u00e7\u00e3o incremental<\/figcaption><\/figure>\n<p class=\"\" data-start=\"2068\" data-end=\"2093\"><strong data-start=\"2068\" data-end=\"2092\">4. Publicar o relat\u00f3rio<\/strong>:<\/p>\n<ul>\n<li data-start=\"2099\" data-end=\"2189\">Publique o relat\u00f3rio em um <strong data-start=\"2126\" data-end=\"2148\">espa\u00e7o de trabalho<\/strong> que n\u00e3o seja o &#8220;Meu espa\u00e7o de trabalho&#8221;.<\/li>\n<\/ul>\n<p class=\"\" data-start=\"2194\" data-end=\"2228\"><strong data-start=\"2194\" data-end=\"2227\">5. Configurar o modelo sem\u00e2ntico<\/strong>:<\/p>\n<ul data-start=\"2232\" data-end=\"2378\">\n<li class=\"\" data-start=\"2232\" data-end=\"2378\">\n<p class=\"\" data-start=\"2234\" data-end=\"2293\">No Power BI Service, acesse o modelo sem\u00e2ntico e configure:<\/p>\n<ul data-start=\"2299\" data-end=\"2378\">\n<li class=\"\" data-start=\"2299\" data-end=\"2333\">\n<p class=\"\" data-start=\"2301\" data-end=\"2333\"><strong data-start=\"2301\" data-end=\"2332\">Conex\u00f5es de gateway e nuvem<\/strong>.<\/p>\n<\/li>\n<li class=\"\" data-start=\"2339\" data-end=\"2378\">\n<p class=\"\" data-start=\"2341\" data-end=\"2378\"><strong data-start=\"2341\" data-end=\"2367\">Atualiza\u00e7\u00e3o autom\u00e1tica<\/strong> do modelo.<\/p>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<figure id=\"attachment_16649\" style=\"width: 1188px\"  class=\"wp-caption aligncenter\"><img loading=\"lazy\" class=\"wp-image-16649 size-full\" src=\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2024\/12\/16616\/ConexaoGatewayPBI.png\" alt=\"\" width=\"1188\" height=\"799\" srcset=\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2024\/12\/16616\/ConexaoGatewayPBI.png 1188w, https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2024\/12\/16616\/ConexaoGatewayPBI-300x202.png 300w, https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2024\/12\/16616\/ConexaoGatewayPBI-1024x689.png 1024w, https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2024\/12\/16616\/ConexaoGatewayPBI-768x517.png 768w, https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2024\/12\/16616\/ConexaoGatewayPBI-272x182.png 272w\" sizes=\"(max-width: 1188px) 100vw, 1188px\" \/><figcaption class=\"wp-caption-text\">Conex\u00f5es de gateway e nuvem<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_16650\" style=\"width: 582px\"  class=\"wp-caption aligncenter\"><img loading=\"lazy\" class=\"size-full wp-image-16650\" src=\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2024\/12\/16616\/AtualizacaoAutoPBI.png\" alt=\"\" width=\"582\" height=\"692\" srcset=\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2024\/12\/16616\/AtualizacaoAutoPBI.png 582w, https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2024\/12\/16616\/AtualizacaoAutoPBI-252x300.png 252w\" sizes=\"(max-width: 582px) 100vw, 582px\" \/><figcaption class=\"wp-caption-text\">Atualiza\u00e7\u00e3o autom\u00e1tica do modelo sem\u00e2ntico<\/figcaption><\/figure>\n<h2 class=\"\" data-start=\"2385\" data-end=\"2425\">Benef\u00edcios da atualiza\u00e7\u00e3o incremental<\/h2>\n<ul data-start=\"2427\" data-end=\"2554\">\n<li class=\"\" data-start=\"2427\" data-end=\"2474\">\n<p class=\"\" data-start=\"2429\" data-end=\"2474\">Mant\u00e9m apenas o per\u00edodo configurado de dados.<\/p>\n<\/li>\n<li class=\"\" data-start=\"2475\" data-end=\"2514\">\n<p class=\"\" data-start=\"2477\" data-end=\"2514\">Evita recarga total da base de dados.<\/p>\n<\/li>\n<li class=\"\" data-start=\"2515\" data-end=\"2554\">\n<p class=\"\" data-start=\"2517\" data-end=\"2554\">Automatiza o processo de atualiza\u00e7\u00e3o.<\/p>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>A escolha da ferramenta de visualiza\u00e7\u00e3o e an\u00e1lise de dados depende do perfil do usu\u00e1rio da informa\u00e7\u00e3o. Para usu\u00e1rios que necessitam de dashboards e relat\u00f3rios interativos, uma solu\u00e7\u00e3o comum \u00e9&hellip;<\/p>\n","protected":false},"author":22,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0},"categories":[676],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Visualizando dados do EPM no Power BI.<\/title>\n<meta name=\"description\" content=\"Veja como configurar o Power BI para visualizar dados do EPM, usando o EPM OLEDB Provider e atualiza\u00e7\u00e3o incremental via Power BI Gateway.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kb.elipse.com.br\/visualizando-dados-do-epm-no-power-bi\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Visualizando dados do EPM no Power BI.\" \/>\n<meta property=\"og:description\" content=\"Veja como configurar o Power BI para visualizar dados do EPM, usando o EPM OLEDB Provider e atualiza\u00e7\u00e3o incremental via Power BI Gateway.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kb.elipse.com.br\/visualizando-dados-do-epm-no-power-bi\/\" \/>\n<meta property=\"og:site_name\" content=\"Elipse Knowledgebase\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/elipsesoftware\" \/>\n<meta property=\"article:published_time\" content=\"2025-04-28T17:25:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-28T18:14:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2024\/11\/16616\/OLEDBMngr.png\" \/>\n<meta name=\"author\" content=\"Samir Lima\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Samir Lima\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/kb.elipse.com.br\/visualizando-dados-do-epm-no-power-bi\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/visualizando-dados-do-epm-no-power-bi\/\"},\"author\":{\"name\":\"Samir Lima\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/6187f4add11d5e8b204dc7032d2f15cf\"},\"headline\":\"Visualizando dados do EPM no Power BI.\",\"datePublished\":\"2025-04-28T17:25:45+00:00\",\"dateModified\":\"2025-04-28T18:14:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/kb.elipse.com.br\/visualizando-dados-do-epm-no-power-bi\/\"},\"wordCount\":790,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\"},\"articleSection\":[\"Elipse Plant Manager\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/kb.elipse.com.br\/visualizando-dados-do-epm-no-power-bi\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/kb.elipse.com.br\/visualizando-dados-do-epm-no-power-bi\/\",\"url\":\"https:\/\/kb.elipse.com.br\/visualizando-dados-do-epm-no-power-bi\/\",\"name\":\"Visualizando dados do EPM no Power BI.\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#website\"},\"datePublished\":\"2025-04-28T17:25:45+00:00\",\"dateModified\":\"2025-04-28T18:14:53+00:00\",\"description\":\"Veja como configurar o Power BI para visualizar dados do EPM, usando o EPM OLEDB Provider e atualiza\u00e7\u00e3o incremental via Power BI Gateway.\",\"breadcrumb\":{\"@id\":\"https:\/\/kb.elipse.com.br\/visualizando-dados-do-epm-no-power-bi\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/kb.elipse.com.br\/visualizando-dados-do-epm-no-power-bi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/kb.elipse.com.br\/visualizando-dados-do-epm-no-power-bi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\/\/kb.elipse.com.br\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Visualizando dados do EPM no Power BI.\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/kb.elipse.com.br\/#website\",\"url\":\"https:\/\/kb.elipse.com.br\/\",\"name\":\"Elipse Knowledgebase\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/kb.elipse.com.br\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\",\"name\":\"Elipse Software\",\"url\":\"https:\/\/kb.elipse.com.br\/\",\"sameAs\":[\"http:\/\/www.facebook.com\/elipsesoftware\"],\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png\",\"contentUrl\":\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png\",\"width\":161,\"height\":58,\"caption\":\"Elipse Software\"},\"image\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/6187f4add11d5e8b204dc7032d2f15cf\",\"name\":\"Samir Lima\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e9f438f26a32e9429a4f6073c6598fae?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e9f438f26a32e9429a4f6073c6598fae?s=96&d=mm&r=g\",\"caption\":\"Samir Lima\"},\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/samirlima\"],\"url\":\"https:\/\/kb.elipse.com.br\/en\/author\/samir\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Visualizando dados do EPM no Power BI.","description":"Veja como configurar o Power BI para visualizar dados do EPM, usando o EPM OLEDB Provider e atualiza\u00e7\u00e3o incremental via Power BI Gateway.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/kb.elipse.com.br\/visualizando-dados-do-epm-no-power-bi\/","og_locale":"en_US","og_type":"article","og_title":"Visualizando dados do EPM no Power BI.","og_description":"Veja como configurar o Power BI para visualizar dados do EPM, usando o EPM OLEDB Provider e atualiza\u00e7\u00e3o incremental via Power BI Gateway.","og_url":"https:\/\/kb.elipse.com.br\/visualizando-dados-do-epm-no-power-bi\/","og_site_name":"Elipse Knowledgebase","article_publisher":"http:\/\/www.facebook.com\/elipsesoftware","article_published_time":"2025-04-28T17:25:45+00:00","article_modified_time":"2025-04-28T18:14:53+00:00","og_image":[{"url":"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2024\/11\/16616\/OLEDBMngr.png"}],"author":"Samir Lima","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Samir Lima","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kb.elipse.com.br\/visualizando-dados-do-epm-no-power-bi\/#article","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/visualizando-dados-do-epm-no-power-bi\/"},"author":{"name":"Samir Lima","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/6187f4add11d5e8b204dc7032d2f15cf"},"headline":"Visualizando dados do EPM no Power BI.","datePublished":"2025-04-28T17:25:45+00:00","dateModified":"2025-04-28T18:14:53+00:00","mainEntityOfPage":{"@id":"https:\/\/kb.elipse.com.br\/visualizando-dados-do-epm-no-power-bi\/"},"wordCount":790,"commentCount":0,"publisher":{"@id":"https:\/\/kb.elipse.com.br\/#organization"},"articleSection":["Elipse Plant Manager"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kb.elipse.com.br\/visualizando-dados-do-epm-no-power-bi\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kb.elipse.com.br\/visualizando-dados-do-epm-no-power-bi\/","url":"https:\/\/kb.elipse.com.br\/visualizando-dados-do-epm-no-power-bi\/","name":"Visualizando dados do EPM no Power BI.","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/#website"},"datePublished":"2025-04-28T17:25:45+00:00","dateModified":"2025-04-28T18:14:53+00:00","description":"Veja como configurar o Power BI para visualizar dados do EPM, usando o EPM OLEDB Provider e atualiza\u00e7\u00e3o incremental via Power BI Gateway.","breadcrumb":{"@id":"https:\/\/kb.elipse.com.br\/visualizando-dados-do-epm-no-power-bi\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kb.elipse.com.br\/visualizando-dados-do-epm-no-power-bi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kb.elipse.com.br\/visualizando-dados-do-epm-no-power-bi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/kb.elipse.com.br\/en\/"},{"@type":"ListItem","position":2,"name":"Visualizando dados do EPM no Power BI."}]},{"@type":"WebSite","@id":"https:\/\/kb.elipse.com.br\/#website","url":"https:\/\/kb.elipse.com.br\/","name":"Elipse Knowledgebase","description":"","publisher":{"@id":"https:\/\/kb.elipse.com.br\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kb.elipse.com.br\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/kb.elipse.com.br\/#organization","name":"Elipse Software","url":"https:\/\/kb.elipse.com.br\/","sameAs":["http:\/\/www.facebook.com\/elipsesoftware"],"logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/","url":"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png","contentUrl":"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png","width":161,"height":58,"caption":"Elipse Software"},"image":{"@id":"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/6187f4add11d5e8b204dc7032d2f15cf","name":"Samir Lima","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/e9f438f26a32e9429a4f6073c6598fae?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e9f438f26a32e9429a4f6073c6598fae?s=96&d=mm&r=g","caption":"Samir Lima"},"sameAs":["https:\/\/www.linkedin.com\/in\/samirlima"],"url":"https:\/\/kb.elipse.com.br\/en\/author\/samir\/"}]}},"_links":{"self":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/16616"}],"collection":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/users\/22"}],"replies":[{"embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/comments?post=16616"}],"version-history":[{"count":11,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/16616\/revisions"}],"predecessor-version":[{"id":16918,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/16616\/revisions\/16918"}],"wp:attachment":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/media?parent=16616"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/categories?post=16616"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/tags?post=16616"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}