{"id":12380,"date":"2026-07-24T12:40:46","date_gmt":"2026-07-24T12:40:46","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=12380"},"modified":"2026-07-24T12:40:46","modified_gmt":"2026-07-24T12:40:46","slug":"how-to-get-data-from-cin7-into-power-bi","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/how-to-get-data-from-cin7-into-power-bi\/","title":{"rendered":"How to get data from Cin7 into Power BI"},"content":{"rendered":"<h2>Introduction<\/h2>\n<p><a href=\"https:\/\/www.cin7.com\/\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/cin7-logo.png\" alt=\"Cin7\" width=\"150\" height=\"150\" \/><\/a>Cin7 is a connected inventory and order management platform used by growing businesses to synchronise products, stock, orders, and customer data across sales channels. Many organisations need Cin7 data in Power BI to monitor inventory health, order trends, and fulfilment performance.<\/p>\n<p>Using the ZappySys ODBC Driver for REST APIs, you can query Cin7 REST API data with SQL and load it into Power BI without writing custom connector code.<\/p>\n<p>This tutorial shows how to create a Cin7 ODBC DSN, configure API authentication, preview data, connect Power BI, and run practical SQL queries.<\/p>\n<div class=\"content_block\" id=\"custom_post_widget-9166\"><h2>Prerequisites<\/h2>\r\nTo access your data in your app using the ODBC Driver, ensure the following requirements are met.\r\n\r\nDownload and install <a href=\"https:\/\/zappysys.com\/products\/odbc-powerpack\/download\/\" rel=\"noopener\">ZappySys ODBC PowerPack<\/a><\/div>\n<h2>Steps<\/h2>\n<h3>Get Cin7 API Credentials<\/h3>\n<ol>\n<li>Sign in to your <a href=\"https:\/\/go.cin7.com\/cloud\/apiSetup\">Cin7 account<\/a>.<\/li>\n<li>Open <strong>Settings \u2192 Integrations &amp; API \u2192 API v1<\/strong> in your Cin7 admin portal.\n<ul>\n<li>Note your <strong>API Username<\/strong> shown on the page.<\/li>\n<li>Click <strong>Add New API Connection<\/strong>, give it a name (e.g. ZappySys), and copy the generated <strong>API Key<\/strong>.<\/li>\n<\/ul>\n<div id=\"attachment_12374\" style=\"width: 1002px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-generate-new-token.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-12374\" class=\"size-full wp-image-12374\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-generate-new-token.png\" alt=\"\" width=\"992\" height=\"436\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-generate-new-token.png 992w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-generate-new-token-300x132.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-generate-new-token-768x338.png 768w\" sizes=\"(max-width: 992px) 100vw, 992px\" \/><\/a><p id=\"caption-attachment-12374\" class=\"wp-caption-text\">Cin7 &#8211; Generate new API connection<\/p><\/div><\/li>\n<li>Store both values securely \u2014 the <strong>API Username<\/strong> and <strong>API Key<\/strong> together act as your login credentials.\n<div id=\"attachment_12375\" style=\"width: 685px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-new-token.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-12375\" class=\"size-full wp-image-12375\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-new-token.png\" alt=\"\" width=\"675\" height=\"327\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-new-token.png 675w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-new-token-300x145.png 300w\" sizes=\"(max-width: 675px) 100vw, 675px\" \/><\/a><p id=\"caption-attachment-12375\" class=\"wp-caption-text\">Cin7 &#8211; API credentials<\/p><\/div><\/li>\n<li>Note your API base URL: <code>https:\/\/api.cin7.com\/api<\/code>.<\/li>\n<\/ol>\n<h3>Create a New ODBC DSN Using 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>, then 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 Cin7 API Connection<\/h3>\n<ol>\n<li>Enter a Cin7 endpoint URL in this format:<br \/>\n<span style=\"color: #222222; font-family: monospace;\"><span style=\"background-color: #e9ebec;\">https:\/\/api.cin7.com\/api\/v1\/Products<\/span><\/span><\/li>\n<li>In <strong>Connection Type<\/strong>, select <strong>HTTP<\/strong> and click <strong>Configure<\/strong>.<\/li>\n<li>Set <strong>Credential Type<\/strong> to <strong>Basic Auth (Username\/Password)<\/strong>.<\/li>\n<li>Set <strong>Username<\/strong> to your Cin7 API Username.<\/li>\n<li>Set <strong>Password<\/strong> to your Cin7 API Key.<\/li>\n<li>Click <strong>OK<\/strong> to save HTTP authentication settings.\n<div id=\"attachment_12384\" style=\"width: 628px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-ODBC-HTTP-connection-configuration.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-12384\" class=\"size-full wp-image-12384\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-ODBC-HTTP-connection-configuration.png\" alt=\"\" width=\"618\" height=\"445\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-ODBC-HTTP-connection-configuration.png 618w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-ODBC-HTTP-connection-configuration-300x216.png 300w\" sizes=\"(max-width: 618px) 100vw, 618px\" \/><\/a><p id=\"caption-attachment-12384\" class=\"wp-caption-text\">Cin7 &#8211; ODBC HTTP connection configuration<\/p><\/div><\/li>\n<li>Set <strong>HTTP Request Method<\/strong> to <strong>GET<\/strong>.<\/li>\n<li>Set <strong>JSON Path Filter<\/strong> to <code>$.Products[*]<\/code> for the Products endpoint.<\/li>\n<li>Click <strong>Test Connection<\/strong>, then click <strong>OK<\/strong> to save the DSN.\n<div id=\"attachment_12385\" style=\"width: 814px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-JSON-Driver-configuration.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-12385\" class=\"size-full wp-image-12385\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-JSON-Driver-configuration.png\" alt=\"\" width=\"804\" height=\"704\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-JSON-Driver-configuration.png 804w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-JSON-Driver-configuration-300x263.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-JSON-Driver-configuration-768x672.png 768w\" sizes=\"(max-width: 804px) 100vw, 804px\" \/><\/a><p id=\"caption-attachment-12385\" class=\"wp-caption-text\">Cin7 &#8211; JSON Driver configuration<\/p><\/div><\/li>\n<\/ol>\n<h3>Preview Cin7 Data in ODBC Driver<\/h3>\n<ol>\n<li>Open the <strong>Preview<\/strong> tab in the DSN configuration window.<\/li>\n<li>Generate a query and click <strong>Preview Data<\/strong>.<\/li>\n<li>Confirm rows are returned. If not, recheck endpoint URL, credentials, and JSON Path Filter.\n<div id=\"attachment_12386\" style=\"width: 814px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-JSON-Driver-result.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-12386\" class=\"size-full wp-image-12386\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-JSON-Driver-result.png\" alt=\"\" width=\"804\" height=\"611\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-JSON-Driver-result.png 804w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-JSON-Driver-result-300x228.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-JSON-Driver-result-768x584.png 768w\" sizes=\"(max-width: 804px) 100vw, 804px\" \/><\/a><p id=\"caption-attachment-12386\" class=\"wp-caption-text\">Cin7 &#8211; JSON Driver result<\/p><\/div><\/li>\n<\/ol>\n<h3>Connect Power BI to Cin7 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 Cin7 DSN from the data source list.<\/li>\n<li>Optionally enter a custom SQL query in <strong>Advanced options<\/strong>.\n<div id=\"attachment_12388\" style=\"width: 712px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-Power-BI-select-driver.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-12388\" class=\"size-full wp-image-12388\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-Power-BI-select-driver.png\" alt=\"\" width=\"702\" height=\"533\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-Power-BI-select-driver.png 702w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-Power-BI-select-driver-300x228.png 300w\" sizes=\"(max-width: 702px) 100vw, 702px\" \/><\/a><p id=\"caption-attachment-12388\" class=\"wp-caption-text\">Cin7 &#8211; Power BI select driver<\/p><\/div><\/li>\n<li>Click <strong>OK<\/strong>, review the preview, and click <strong>Load<\/strong>.\n<div id=\"attachment_12387\" style=\"width: 890px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-Power-BI-result.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-12387\" class=\"size-full wp-image-12387\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-Power-BI-result.png\" alt=\"\" width=\"880\" height=\"219\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-Power-BI-result.png 880w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-Power-BI-result-300x75.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-Power-BI-result-768x191.png 768w\" sizes=\"(max-width: 880px) 100vw, 880px\" \/><\/a><p id=\"caption-attachment-12387\" class=\"wp-caption-text\">Cin7 &#8211; Power BI result<\/p><\/div><\/li>\n<li>In the Navigator, select fields or tables you want to import into your model.<\/li>\n<\/ol>\n<h3>Query Cin7 Data with SQL<\/h3>\n<p>Use custom SQL queries in the ODBC driver or Power BI to shape data before loading.<\/p>\n<p><strong>Example 1: List Products<\/strong><\/p>\n<pre class=\"lang:sql decode:true\">SELECT\r\n    ID,\r\n    StyleCode,\r\n    Name,\r\n    Category,\r\n    Brand,\r\n    IsActive,\r\n    ModifiedDate\r\nFROM Products<\/pre>\n<p><strong>Example 2: Active Products Only<\/strong><\/p>\n<pre class=\"lang:sql decode:true\">SELECT\r\n    ID,\r\n    StyleCode,\r\n    Name,\r\n    IsActive\r\nFROM Products\r\nWHERE IsActive=true<\/pre>\n<p><strong>Example 3: Recently Modified Products (Last 30 Days)<\/strong><\/p>\n<pre class=\"lang:sql decode:true\">SELECT\r\n    ID,\r\n    StyleCode,\r\n    Name,\r\n    ModifiedDate\r\nFROM Products\r\nWHERE ModifiedDate &gt;= &lt;&lt;today-10d,FUN_TO_DATE&gt;&gt;<\/pre>\n<h2>Conclusion<\/h2>\n<p>Connecting Cin7 to Power BI using the ZappySys ODBC Driver gives you a fast, SQL-friendly way to build inventory and sales analytics from Cin7 API data. You can centralise operational data, model it in Power BI, and publish dashboards without building custom connectors.<\/p>\n<p>Explore the full capabilities of the <a href=\"https:\/\/zappysys.com\/products\/odbc-drivers\/\" target=\"_blank\" rel=\"noopener\">ZappySys ODBC Drivers<\/a> to integrate Cin7 and other APIs into your reporting workflow.<\/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 Cin7 is a connected inventory and order management platform used by growing businesses to synchronise products, stock, orders, and customer data across sales channels. Many organisations need Cin7 data in Power BI to monitor inventory health, order trends, and fulfilment performance. Using the ZappySys ODBC Driver for REST APIs, you can query Cin7 REST [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":12372,"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 Cin7 into Power BI | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"How to get data from Cin7 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-cin7-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 Cin7 into Power BI | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"How to get data from Cin7 into Power BI - ZappySys Blog\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/how-to-get-data-from-cin7-into-power-bi\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:published_time\" content=\"2026-07-24T12:40:46+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-logo.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"225\" \/>\r\n\t<meta property=\"og:image:height\" content=\"225\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\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-cin7-into-power-bi\/\",\"url\":\"https:\/\/zappysys.com\/blog\/how-to-get-data-from-cin7-into-power-bi\/\",\"name\":\"How to get data from Cin7 into Power BI | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/how-to-get-data-from-cin7-into-power-bi\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/how-to-get-data-from-cin7-into-power-bi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-logo.png\",\"datePublished\":\"2026-07-24T12:40:46+00:00\",\"dateModified\":\"2026-07-24T12:40:46+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e\"},\"description\":\"How to get data from Cin7 into Power BI - ZappySys Blog\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/how-to-get-data-from-cin7-into-power-bi\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/how-to-get-data-from-cin7-into-power-bi\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/how-to-get-data-from-cin7-into-power-bi\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-logo.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-logo.png\",\"width\":225,\"height\":225},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/how-to-get-data-from-cin7-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 Cin7 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 Cin7 into Power BI | ZappySys Blog","description":"How to get data from Cin7 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-cin7-into-power-bi\/","og_locale":"en_US","og_type":"article","og_title":"How to get data from Cin7 into Power BI | ZappySys Blog","og_description":"How to get data from Cin7 into Power BI - ZappySys Blog","og_url":"https:\/\/zappysys.com\/blog\/how-to-get-data-from-cin7-into-power-bi\/","og_site_name":"ZappySys Blog","article_published_time":"2026-07-24T12:40:46+00:00","og_image":[{"width":225,"height":225,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-logo.png","type":"image\/png"}],"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-cin7-into-power-bi\/","url":"https:\/\/zappysys.com\/blog\/how-to-get-data-from-cin7-into-power-bi\/","name":"How to get data from Cin7 into Power BI | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/how-to-get-data-from-cin7-into-power-bi\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/how-to-get-data-from-cin7-into-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-logo.png","datePublished":"2026-07-24T12:40:46+00:00","dateModified":"2026-07-24T12:40:46+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e"},"description":"How to get data from Cin7 into Power BI - ZappySys Blog","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/how-to-get-data-from-cin7-into-power-bi\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/how-to-get-data-from-cin7-into-power-bi\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/how-to-get-data-from-cin7-into-power-bi\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-logo.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/07\/Cin7-logo.png","width":225,"height":225},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/how-to-get-data-from-cin7-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 Cin7 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\/12380"}],"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=12380"}],"version-history":[{"count":3,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/12380\/revisions"}],"predecessor-version":[{"id":12392,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/12380\/revisions\/12392"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/12372"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=12380"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=12380"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=12380"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}