{"id":12439,"date":"2026-08-27T22:28:52","date_gmt":"2026-08-27T22:28:52","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=12439"},"modified":"2026-08-27T22:28:52","modified_gmt":"2026-08-27T22:28:52","slug":"how-to-get-data-from-hivebrite-into-power-bi","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/how-to-get-data-from-hivebrite-into-power-bi\/","title":{"rendered":"How to get data from Hivebrite into Power BI"},"content":{"rendered":"<h2>Introduction<\/h2>\n<p><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-logo.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-12406 alignleft\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-logo-150x150.jpg\" alt=\"\" width=\"112\" height=\"112\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-logo-150x150.jpg 150w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-logo-300x300.jpg 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-logo.jpg 447w\" sizes=\"(max-width: 112px) 100vw, 112px\" \/><\/a>Hivebrite is a community management platform used for memberships, events, directories, and engagement workflows. Many organizations store operational data in Hivebrite and need to migrate it to Power BI for reporting, analytics, and business intelligence.<\/p>\n<p>In this tutorial, you will learn how to read Hivebrite API data directly from Power BI by using the ZappySys JSON Driver (part of ODBC PowerPack). You will configure OAuth2 authentication, handle pagination, preview the data inside the driver, and then load it into a Power BI model \u2014 without writing a custom API client.<\/p>\n<div class=\"content_block\" id=\"custom_post_widget-2523\"><h2><span id=\"Prerequisites\">Prerequisites<\/span><\/h2>\r\nBefore we perform the steps listed in this article, make sure the prerequisites are met:\r\n<ol style=\"margin-left: 1.5em;\">\r\n \t<li>Basic knowledge of SSIS package\u00a0development using\u00a0<em>Microsoft SQL Server Integration Services<\/em>.<\/li>\r\n \t<li>Make sure the <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/ssdt\/download-sql-server-data-tools-ssdt\">SSIS designer<\/a> is installed.<\/li>\r\n \t<li>Download and install <a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/download\/\">ZappySys SSIS PowerPack<\/a>.<\/li>\r\n<\/ol>\r\n<strong>NOTE:<\/strong> If you are planning to deploy packages to a server and schedule their execution later, <a href=\"https:\/\/zappysys.zendesk.com\/hc\/en-us\/articles\/360035974593\" target=\"_blank\" rel=\"noopener\">read this article<\/a>.<\/div>\n<h2>Steps<\/h2>\n<h3>Prepare Hivebrite API access<\/h3>\n<ol>\n<li>Sign in to your Hivebrite <a href=\"https:\/\/support.hivebrite.com\/hc\/en-us\/articles\/12953361732508\">admin area<\/a> and go to <strong>Integrations \u2192 External Integrations<\/strong>.<\/li>\n<li>Click <strong>Create a Service App<\/strong> and give it a name.\n<ul>\n<li>Copy the <strong>Client ID<\/strong> (UUID) and <strong>Client Secret<\/strong> shown at creation \u2014 the secret is displayed only once and cannot be retrieved afterward.<\/li>\n<\/ul>\n<\/li>\n<li>Identify your <strong>Authorization Host<\/strong> based on the zone that hosts your community:\n<ul>\n<li><strong>US:<\/strong> <code>auth.us.hivebrite.com<\/code><\/li>\n<li><strong>EU:<\/strong> <code>auth.eu.hivebrite.com<\/code><\/li>\n<li><strong>APAC:<\/strong> <code>auth.apac.hivebrite.com<\/code><\/li>\n<li><strong>CH:<\/strong> <code>auth.ch.hivebrite.com<\/code><\/li>\n<\/ul>\n<\/li>\n<li>Note your community API host \u2014 it is your own subdomain, for example <code>https:\/\/{your-community}.hivebrite.com<\/code>.<\/li>\n<li>Confirm which entities you need to extract (for example: members, events, groups, or donations).<\/li>\n<\/ol>\n<h3>Create a new ODBC DSN using the ZappySys JSON Driver<\/h3>\n<ol>\n<li>Search for <strong>ODBC<\/strong> in the Windows Start menu and open <strong>ODBC Data Source Administrator<\/strong>.<br \/>\n<a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/01\/how-to-open-odbc-data-source-administrator-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6213\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/01\/how-to-open-odbc-data-source-administrator-2.png\" alt=\"\" width=\"394\" height=\"542\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/01\/how-to-open-odbc-data-source-administrator-2.png 394w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/01\/how-to-open-odbc-data-source-administrator-2-218x300.png 218w\" sizes=\"(max-width: 394px) 100vw, 394px\" \/><\/a><\/li>\n<li>In <strong>User DSN<\/strong> or <strong>System DSN<\/strong>, click <strong>Add<\/strong>.<\/li>\n<li>Select <strong>ZappySys JSON Driver<\/strong> and click <strong>Continue<\/strong>.<br \/>\n<a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/01\/odbc-dsn-admin-create-dsn-based-on-json-driver.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5919\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/01\/odbc-dsn-admin-create-dsn-based-on-json-driver.png\" alt=\"\" width=\"593\" height=\"504\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/01\/odbc-dsn-admin-create-dsn-based-on-json-driver.png 593w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/01\/odbc-dsn-admin-create-dsn-based-on-json-driver-300x255.png 300w\" sizes=\"(max-width: 593px) 100vw, 593px\" \/><\/a><\/li>\n<\/ol>\n<h3>Configure the Connection and API Settings<\/h3>\n<ol>\n<li>Set the <strong>Data Source Path or URL<\/strong> to the endpoint you want to read. Example for members:\n<pre class=\"lang:default decode:true\">https:\/\/{your-community}.hivebrite.com\/admin\/v4\/members<\/pre>\n<\/li>\n<li>In the driver window, set <strong>Connection Type<\/strong> to <strong>HTTP<\/strong> and click <strong>Configure<\/strong>.<\/li>\n<li>Set <strong>Credential Type<\/strong> to <strong>OAuth<\/strong>.<\/li>\n<li>Fill in the OAuth settings:\n<ul>\n<li><strong>OAuth Provider:<\/strong> Custom<\/li>\n<li><strong>OAuth Version:<\/strong> OAuth2<\/li>\n<li><strong>Grant Type:<\/strong> Client Credentials Grant<\/li>\n<li><strong>Client ID:<\/strong> your Hivebrite Client ID (UUID)<\/li>\n<li><strong>Client Secret:<\/strong> your Hivebrite Client Secret<\/li>\n<li><strong>Access Token URL:<\/strong> <code>https:\/\/auth.{zone}.hivebrite.com\/oauth2\/token<\/code><\/li>\n<li><strong>Scopes \/ Permissions:<\/strong> leave empty\n<div id=\"attachment_12446\" style=\"width: 628px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-ODBC-OAuth-connection-configuration.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-12446\" class=\"size-full wp-image-12446\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-ODBC-OAuth-connection-configuration.png\" alt=\"\" width=\"618\" height=\"454\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-ODBC-OAuth-connection-configuration.png 618w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-ODBC-OAuth-connection-configuration-300x220.png 300w\" sizes=\"(max-width: 618px) 100vw, 618px\" \/><\/a><p id=\"caption-attachment-12446\" class=\"wp-caption-text\">Hivebrite &#8211; ODBC OAuth connection configuration<\/p><\/div><\/li>\n<\/ul>\n<\/li>\n<li>Go to the <strong>Grant Options<\/strong> tab and add the following under <strong>Extra attributes for the token request<\/strong>:\n<pre class=\"lang:default decode:true\">audience=partner<\/pre>\n<\/li>\n<li>Click <strong>OK <\/strong>to save the configuration.\n<div id=\"attachment_12445\" style=\"width: 628px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-ODBC-OAuth-connection-configuration-advanced.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-12445\" class=\"size-full wp-image-12445\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-ODBC-OAuth-connection-configuration-advanced.png\" alt=\"\" width=\"618\" height=\"578\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-ODBC-OAuth-connection-configuration-advanced.png 618w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-ODBC-OAuth-connection-configuration-advanced-300x281.png 300w\" sizes=\"(max-width: 618px) 100vw, 618px\" \/><\/a><p id=\"caption-attachment-12445\" class=\"wp-caption-text\">Hivebrite &#8211; ODBC OAuth connection configuration advanced.<\/p><\/div><\/li>\n<li>Set <strong>HTTP Request Method<\/strong> to <strong>GET<\/strong>.<\/li>\n<li>Add the request header:\n<ul>\n<li><code>Accept: application\/json<\/code><\/li>\n<\/ul>\n<\/li>\n<li>Set the <strong>Array Filter<\/strong> (JSON Path) to <code>$.data[*]<\/code> \u2014 Hivebrite wraps collection responses in an <code>data<\/code> array. If you leave the filter empty, the driver will return a single row containing the envelope instead of one row per record.<\/li>\n<li>Click <strong>Test Connection<\/strong>, then <strong>OK<\/strong> to save the DSN.\n<div id=\"attachment_12444\" style=\"width: 814px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-ODBC-JSON-Driver-configuration.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-12444\" class=\"size-full wp-image-12444\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-ODBC-JSON-Driver-configuration.png\" alt=\"\" width=\"804\" height=\"704\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-ODBC-JSON-Driver-configuration.png 804w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-ODBC-JSON-Driver-configuration-300x263.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-ODBC-JSON-Driver-configuration-768x672.png 768w\" sizes=\"(max-width: 804px) 100vw, 804px\" \/><\/a><p id=\"caption-attachment-12444\" class=\"wp-caption-text\">Hivebrite &#8211; ODBC JSON Driver configuration<\/p><\/div><\/li>\n<\/ol>\n<h3>Preview Hivebrite data in the ODBC driver<\/h3>\n<ol>\n<li>Go to the <strong>Preview<\/strong> tab.<\/li>\n<li>Adjust the generated query if needed, then click <strong>Preview Data<\/strong>.<\/li>\n<li>Confirm that you get one row per Hivebrite record and that the columns are flattened as expected. Validate here before moving to Power BI \u2014 troubleshooting is much faster inside the driver.\n<div id=\"attachment_12443\" style=\"width: 814px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-ODBC-JSON-Driver-result.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-12443\" class=\"size-full wp-image-12443\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-ODBC-JSON-Driver-result.png\" alt=\"\" width=\"804\" height=\"609\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-ODBC-JSON-Driver-result.png 804w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-ODBC-JSON-Driver-result-300x227.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-ODBC-JSON-Driver-result-768x582.png 768w\" sizes=\"(max-width: 804px) 100vw, 804px\" \/><\/a><p id=\"caption-attachment-12443\" class=\"wp-caption-text\">Hivebrite &#8211; ODBC JSON Driver result<\/p><\/div><\/li>\n<\/ol>\n<h3>Connect Power BI to Hivebrite via ODBC<\/h3>\n<ol>\n<li>Open <strong>Power BI Desktop<\/strong>.<\/li>\n<li>Go to <strong>Home<\/strong> &gt; <strong>Get Data<\/strong> &gt; <strong>More&#8230;<\/strong>.<\/li>\n<li>Search for <strong>ODBC<\/strong> and click <strong>Connect<\/strong>.\n<div id=\"attachment_12178\" style=\"width: 1395px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Power-BI-Get-data-from-ODBC-connection.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-12178\" class=\"size-full wp-image-12178\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Power-BI-Get-data-from-ODBC-connection.png\" alt=\"\" width=\"1385\" height=\"782\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Power-BI-Get-data-from-ODBC-connection.png 1385w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Power-BI-Get-data-from-ODBC-connection-300x169.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Power-BI-Get-data-from-ODBC-connection-1024x578.png 1024w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Power-BI-Get-data-from-ODBC-connection-768x434.png 768w\" sizes=\"(max-width: 1385px) 100vw, 1385px\" \/><\/a><p id=\"caption-attachment-12178\" class=\"wp-caption-text\">Power BI &#8211; Get data from ODBC connection<\/p><\/div><\/li>\n<li>Select your Spotify DSN from the data source list.<\/li>\n<li>Optionally enter a custom SQL query in <strong>Advanced options<\/strong>.\n<div id=\"attachment_12442\" style=\"width: 712px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-Power-BI-query.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-12442\" class=\"size-full wp-image-12442\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-Power-BI-query.png\" alt=\"\" width=\"702\" height=\"533\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-Power-BI-query.png 702w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-Power-BI-query-300x228.png 300w\" sizes=\"(max-width: 702px) 100vw, 702px\" \/><\/a><p id=\"caption-attachment-12442\" class=\"wp-caption-text\">Hivebrite &#8211; Power BI query<\/p><\/div><\/li>\n<li>Click <strong>OK<\/strong>, review the preview, and click <strong><strong>Load<br \/>\n<\/strong><\/strong><\/p>\n<div id=\"attachment_12441\" style=\"width: 890px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-Power-BI-result.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-12441\" class=\"size-full wp-image-12441\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-Power-BI-result.png\" alt=\"\" width=\"880\" height=\"213\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-Power-BI-result.png 880w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-Power-BI-result-300x73.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-Power-BI-result-768x186.png 768w\" sizes=\"(max-width: 880px) 100vw, 880px\" \/><\/a><p id=\"caption-attachment-12441\" class=\"wp-caption-text\">Hivebrite &#8211; Power BI result<\/p><\/div><\/li>\n<\/ol>\n<h3>Query Hivebrite data with SQL<\/h3>\n<p><strong>Example 1: Select specific columns<\/strong><\/p>\n<pre class=\"lang:sql decode:true\">SELECT\r\n    id,\r\n    first_name,\r\n    last_name,\r\n    email,\r\n    status,\r\n    created_at,\r\n    updated_at\r\nFROM _root_<\/pre>\n<p><strong>Example 2: Filter and sort<\/strong><\/p>\n<pre class=\"lang:sql decode:true\">SELECT\r\n    id,\r\n    first_name,\r\n    last_name,\r\n    email,\r\n    status,\r\n    created_at\r\nFROM _root_\r\nWHERE status = 'active'\r\nORDER BY created_at DESC<\/pre>\n<p><strong>Example 3: Count members by status<\/strong><\/p>\n<pre class=\"lang:sql decode:true\">SELECT\r\n    status,\r\n    COUNT(*) AS MemberCount\r\nFROM _root_\r\nGROUP BY status<\/pre>\n<h2>Conclusion<\/h2>\n<p>Connecting Hivebrite to Power BI with the ZappySys JSON Driver gives you a repeatable, no-code path from your community platform to your analytics stack. With OAuth2 client credentials handled by the driver, pagination configured once, and server-side filters pushed into the API, you can build reports on members, events, and engagement that refresh on a schedule.<\/p>\n<p>Explore the full capabilities of the <a href=\"https:\/\/zappysys.com\/products\/odbc-powerpack\/\" target=\"_blank\" rel=\"noopener\">ZappySys ODBC PowerPack<\/a> to combine Hivebrite data with your CRM, finance, or marketing sources and build a unified view of your community operations.<\/p>\n<div class=\"content_block\" id=\"custom_post_widget-12354\"><h3>Need Help?<\/h3><p class=\"section-intro\">If you encounter any issues, our support team is here to help:<\/p>\r\n\r\n<ol>\r\n \t<li><strong>Live Chat:<\/strong>\u00a0Open the chat widget\u00a0<em>(bottom right of this page)<\/em><\/li>\r\n \t<li><strong>Email:<\/strong>\u00a0<a href=\"mailto:support@zappysys.com\">support@zappysys.com<\/a><\/li>\r\n \t<li><strong>Support Center:<\/strong>\u00a0<a href=\"https:\/\/zappysys.com\/support\/\">Support | ZappySys<\/a><\/li>\r\n<\/ol><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Introduction Hivebrite is a community management platform used for memberships, events, directories, and engagement workflows. Many organizations store operational data in Hivebrite and need to migrate it to Power BI for reporting, analytics, and business intelligence. In this tutorial, you will learn how to read Hivebrite API data directly from Power BI by using the [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":12406,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>How to get data from Hivebrite into Power BI | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"How to get data from Hivebrite into Power BI - ZappySys Blog\" \/>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/zappysys.com\/blog\/how-to-get-data-from-hivebrite-into-power-bi\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"How to get data from Hivebrite into Power BI | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"How to get data from Hivebrite into Power BI - ZappySys Blog\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/how-to-get-data-from-hivebrite-into-power-bi\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:published_time\" content=\"2026-08-27T22:28:52+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-logo.jpg\" \/>\r\n\t<meta property=\"og:image:width\" content=\"447\" \/>\r\n\t<meta property=\"og:image:height\" content=\"447\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\r\n<meta name=\"author\" content=\"ZappySys Team\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ZappySys Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zappysys.com\/blog\/how-to-get-data-from-hivebrite-into-power-bi\/\",\"url\":\"https:\/\/zappysys.com\/blog\/how-to-get-data-from-hivebrite-into-power-bi\/\",\"name\":\"How to get data from Hivebrite into Power BI | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/how-to-get-data-from-hivebrite-into-power-bi\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/how-to-get-data-from-hivebrite-into-power-bi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-logo.jpg\",\"datePublished\":\"2026-08-27T22:28:52+00:00\",\"dateModified\":\"2026-08-27T22:28:52+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e\"},\"description\":\"How to get data from Hivebrite into Power BI - ZappySys Blog\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/how-to-get-data-from-hivebrite-into-power-bi\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/how-to-get-data-from-hivebrite-into-power-bi\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/how-to-get-data-from-hivebrite-into-power-bi\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-logo.jpg\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-logo.jpg\",\"width\":447,\"height\":447},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/how-to-get-data-from-hivebrite-into-power-bi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to get data from Hivebrite into Power BI\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/zappysys.com\/blog\/#website\",\"url\":\"https:\/\/zappysys.com\/blog\/\",\"name\":\"ZappySys Blog\",\"description\":\"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/zappysys.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e\",\"name\":\"ZappySys Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g\",\"caption\":\"ZappySys Team\"},\"sameAs\":[\"https:\/\/zappysys.com\"],\"url\":\"https:\/\/zappysys.com\/blog\/author\/dcalbimonte\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to get data from Hivebrite into Power BI | ZappySys Blog","description":"How to get data from Hivebrite into Power BI - ZappySys Blog","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:\/\/zappysys.com\/blog\/how-to-get-data-from-hivebrite-into-power-bi\/","og_locale":"en_US","og_type":"article","og_title":"How to get data from Hivebrite into Power BI | ZappySys Blog","og_description":"How to get data from Hivebrite into Power BI - ZappySys Blog","og_url":"https:\/\/zappysys.com\/blog\/how-to-get-data-from-hivebrite-into-power-bi\/","og_site_name":"ZappySys Blog","article_published_time":"2026-08-27T22:28:52+00:00","og_image":[{"width":447,"height":447,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-logo.jpg","type":"image\/jpeg"}],"author":"ZappySys Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"ZappySys Team","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/how-to-get-data-from-hivebrite-into-power-bi\/","url":"https:\/\/zappysys.com\/blog\/how-to-get-data-from-hivebrite-into-power-bi\/","name":"How to get data from Hivebrite into Power BI | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/how-to-get-data-from-hivebrite-into-power-bi\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/how-to-get-data-from-hivebrite-into-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-logo.jpg","datePublished":"2026-08-27T22:28:52+00:00","dateModified":"2026-08-27T22:28:52+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e"},"description":"How to get data from Hivebrite into Power BI - ZappySys Blog","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/how-to-get-data-from-hivebrite-into-power-bi\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/how-to-get-data-from-hivebrite-into-power-bi\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/how-to-get-data-from-hivebrite-into-power-bi\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-logo.jpg","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/08\/Hivebrite-logo.jpg","width":447,"height":447},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/how-to-get-data-from-hivebrite-into-power-bi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to get data from Hivebrite into Power BI"}]},{"@type":"WebSite","@id":"https:\/\/zappysys.com\/blog\/#website","url":"https:\/\/zappysys.com\/blog\/","name":"ZappySys Blog","description":"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/zappysys.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e","name":"ZappySys Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g","caption":"ZappySys Team"},"sameAs":["https:\/\/zappysys.com"],"url":"https:\/\/zappysys.com\/blog\/author\/dcalbimonte\/"}]}},"_links":{"self":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/12439"}],"collection":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/comments?post=12439"}],"version-history":[{"count":2,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/12439\/revisions"}],"predecessor-version":[{"id":12448,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/12439\/revisions\/12448"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/12406"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=12439"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=12439"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=12439"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}