{"id":1252,"date":"2017-07-26T07:13:43","date_gmt":"2017-07-26T12:13:43","guid":{"rendered":"https:\/\/www.teamdesk.net\/blog\/?p=1252"},"modified":"2019-01-10T08:47:38","modified_gmt":"2019-01-10T14:47:38","slug":"power-bi-teamdesk-data-connector","status":"publish","type":"post","link":"https:\/\/www.teamdesk.net\/blog\/whats-new\/power-bi-teamdesk-data-connector\/","title":{"rendered":"Power BI + TeamDesk Data Connector"},"content":{"rendered":"

Information below is no longer accurate. Please check updated article<\/a><\/span><\/strong><\/span><\/p>\n

\n

On May, 2017 Microsoft released<\/a> SDK for creating custom Data Connectors for Power BI. Given this opportunity we are releasing TeamDesk<\/a> Data Connector (Beta) for Power BI.<\/p>\n

Currently Microsoft supports custom connectors on desktop version only, but they plan to extend this technology to Power BI online and, eventually to all their products supporting PowerQuery (M) language, such as Excel and SQL 2017 and distribute connectors via Office Store, so the tech looks promising.<\/p>\n

Try it now!<\/h3>\n

If you want to try it now, you’ll need to follow this steps:<\/p>\n

    \n
  1. Install<\/a> Microsoft Power BI Desktop;<\/li>\n
  2. Create a [My Documents]\\Microsoft Power BI Desktop\\Custom Connectors<\/em> directory;<\/li>\n
  3. Download TeamDesk Data Connector<\/a> into the directory. If browser tries to change file extension to .zip, rename it back to TeamDesk.PowerBI.DataConnector.mez;<\/em><\/li>\n
  4. Enable Custom data connectors<\/em> feature under File > Options and Settings > Options > Preview features<\/em> in Power BI Desktop;<\/li>\n
  5. Restart Power BI Desktop.<\/li>\n<\/ol>\n

    Upon using Get Data, you’ll find TeamDesk connector in Online Services category.<\/p>\n

    \"Select<\/p>\n

    Click on the connector, confirm you are using beta tech and you’ll be prompted to enter your database URL. Simplest way is to copy any database URL from browser window.<\/p>\n

    \"Type<\/p>\n

    Next, enter your TeamDesk email and password:<\/p>\n

    \"Enter<\/p>\n

    Next, connector will prompt you to choose the table and the view to get the data from. On the screenshot is the data from Invoicing\u00a0sample database.<\/p>\n

    \"Select<\/p>\n

    Finally, click Load button to get the data to Power BI:<\/p>\n

    \"The<\/p>\n

    Then transform and visualize the way you want:<\/p>\n

    \"Visualize<\/p>\n

    If you prefer programmability, there are two functions available at your disposal:<\/p>\n

    TeamDesk.SelectView(url<\/em>, table<\/em>, view<\/em>) – given database URL, the name of the table and the name of view retrieves the content.<\/p>\n

    =TeamDesk.SelectView(\"https:\/\/www.teamdesk.net\/secure\/db\/55214\", \"Invoice\", \"List All\")<\/pre>\n
    produces result identical to the sample above. Or, there is even-more low-level function:<\/p>\n
    TeamDesk.Select(url<\/em>, table<\/em>, columns,<\/em> filter<\/em>, sort<\/em>) – allows you to specify the data you need, precisely:<\/p>\n
    =TeamDesk.Select(\"https:\/\/www.teamdesk.net\/secure\/db\/55214\", \"Invoice\", {\"Name\", \"Total\"}, \"[Company]='ABC, Inc.'\", \"Due Date\/\/DESC\")\n<\/pre>\n
    selects customer names and totals from invoices for ABC, Inc. company,\u00a0 and sorts by recent due date on top.<\/p>\n
    Enjoy!<\/p>\n","protected":false},"excerpt":{"rendered":"
    Information below is no longer accurate. Please check updated article On May, 2017 Microsoft released SDK for creating custom Data Connectors for Power BI. Given this opportunity we are releasing TeamDesk Data Connector (Beta) for Power BI.<\/p>\n","protected":false},"author":4,"featured_media":1259,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1252","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-whats-new"],"yoast_head":"\nPower BI + TeamDesk Data Connector - TeamDesk Blog<\/title>\n<meta name=\"description\" content=\"TeamDesk Data Connector for Microsoft Power BI is available for preview. Functionality is currently limited to Power BI Desktop.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.teamdesk.net\/blog\/whats-new\/power-bi-teamdesk-data-connector\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power BI + TeamDesk Data Connector - TeamDesk Blog\" \/>\n<meta property=\"og:description\" content=\"TeamDesk Data Connector for Microsoft Power BI is available for preview. Functionality is currently limited to Power BI Desktop.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.teamdesk.net\/blog\/whats-new\/power-bi-teamdesk-data-connector\/\" \/>\n<meta property=\"og:site_name\" content=\"TeamDesk Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-07-26T12:13:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-01-10T14:47:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2017\/07\/teamdesk_and_powerbi.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"952\" \/>\n\t<meta property=\"og:image:height\" content=\"530\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Kirill Bondar\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirill Bondar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/power-bi-teamdesk-data-connector\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/power-bi-teamdesk-data-connector\\\/\"},\"author\":{\"name\":\"Kirill Bondar\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#\\\/schema\\\/person\\\/22c4c05bd657513c8b00122fa364c8d2\"},\"headline\":\"Power BI + TeamDesk Data Connector\",\"datePublished\":\"2017-07-26T12:13:43+00:00\",\"dateModified\":\"2019-01-10T14:47:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/power-bi-teamdesk-data-connector\\\/\"},\"wordCount\":346,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/power-bi-teamdesk-data-connector\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/07\\\/teamdesk_and_powerbi.jpg\",\"articleSection\":[\"What's New\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/power-bi-teamdesk-data-connector\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/power-bi-teamdesk-data-connector\\\/\",\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/power-bi-teamdesk-data-connector\\\/\",\"name\":\"Power BI + TeamDesk Data Connector - TeamDesk Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/power-bi-teamdesk-data-connector\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/power-bi-teamdesk-data-connector\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/07\\\/teamdesk_and_powerbi.jpg\",\"datePublished\":\"2017-07-26T12:13:43+00:00\",\"dateModified\":\"2019-01-10T14:47:38+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#\\\/schema\\\/person\\\/22c4c05bd657513c8b00122fa364c8d2\"},\"description\":\"TeamDesk Data Connector for Microsoft Power BI is available for preview. Functionality is currently limited to Power BI Desktop.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/power-bi-teamdesk-data-connector\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/power-bi-teamdesk-data-connector\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/power-bi-teamdesk-data-connector\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/07\\\/teamdesk_and_powerbi.jpg\",\"contentUrl\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/07\\\/teamdesk_and_powerbi.jpg\",\"width\":952,\"height\":530},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/whats-new\\\/power-bi-teamdesk-data-connector\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Power BI + TeamDesk Data Connector\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/\",\"name\":\"TeamDesk Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#\\\/schema\\\/person\\\/22c4c05bd657513c8b00122fa364c8d2\",\"name\":\"Kirill Bondar\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/dc5bc844095b5753ccc73c589c028bf16615674f289668146bbd59205a08a52d?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/dc5bc844095b5753ccc73c589c028bf16615674f289668146bbd59205a08a52d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/dc5bc844095b5753ccc73c589c028bf16615674f289668146bbd59205a08a52d?s=96&d=mm&r=g\",\"caption\":\"Kirill Bondar\"},\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/author\\\/kirill-bondar\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Power BI + TeamDesk Data Connector - TeamDesk Blog","description":"TeamDesk Data Connector for Microsoft Power BI is available for preview. Functionality is currently limited to Power BI Desktop.","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:\/\/www.teamdesk.net\/blog\/whats-new\/power-bi-teamdesk-data-connector\/","og_locale":"en_US","og_type":"article","og_title":"Power BI + TeamDesk Data Connector - TeamDesk Blog","og_description":"TeamDesk Data Connector for Microsoft Power BI is available for preview. Functionality is currently limited to Power BI Desktop.","og_url":"https:\/\/www.teamdesk.net\/blog\/whats-new\/power-bi-teamdesk-data-connector\/","og_site_name":"TeamDesk Blog","article_published_time":"2017-07-26T12:13:43+00:00","article_modified_time":"2019-01-10T14:47:38+00:00","og_image":[{"width":952,"height":530,"url":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2017\/07\/teamdesk_and_powerbi.jpg","type":"image\/jpeg"}],"author":"Kirill Bondar","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirill Bondar","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/power-bi-teamdesk-data-connector\/#article","isPartOf":{"@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/power-bi-teamdesk-data-connector\/"},"author":{"name":"Kirill Bondar","@id":"https:\/\/www.teamdesk.net\/blog\/#\/schema\/person\/22c4c05bd657513c8b00122fa364c8d2"},"headline":"Power BI + TeamDesk Data Connector","datePublished":"2017-07-26T12:13:43+00:00","dateModified":"2019-01-10T14:47:38+00:00","mainEntityOfPage":{"@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/power-bi-teamdesk-data-connector\/"},"wordCount":346,"commentCount":0,"image":{"@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/power-bi-teamdesk-data-connector\/#primaryimage"},"thumbnailUrl":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2017\/07\/teamdesk_and_powerbi.jpg","articleSection":["What's New"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.teamdesk.net\/blog\/whats-new\/power-bi-teamdesk-data-connector\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/power-bi-teamdesk-data-connector\/","url":"https:\/\/www.teamdesk.net\/blog\/whats-new\/power-bi-teamdesk-data-connector\/","name":"Power BI + TeamDesk Data Connector - TeamDesk Blog","isPartOf":{"@id":"https:\/\/www.teamdesk.net\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/power-bi-teamdesk-data-connector\/#primaryimage"},"image":{"@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/power-bi-teamdesk-data-connector\/#primaryimage"},"thumbnailUrl":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2017\/07\/teamdesk_and_powerbi.jpg","datePublished":"2017-07-26T12:13:43+00:00","dateModified":"2019-01-10T14:47:38+00:00","author":{"@id":"https:\/\/www.teamdesk.net\/blog\/#\/schema\/person\/22c4c05bd657513c8b00122fa364c8d2"},"description":"TeamDesk Data Connector for Microsoft Power BI is available for preview. Functionality is currently limited to Power BI Desktop.","breadcrumb":{"@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/power-bi-teamdesk-data-connector\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.teamdesk.net\/blog\/whats-new\/power-bi-teamdesk-data-connector\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/power-bi-teamdesk-data-connector\/#primaryimage","url":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2017\/07\/teamdesk_and_powerbi.jpg","contentUrl":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2017\/07\/teamdesk_and_powerbi.jpg","width":952,"height":530},{"@type":"BreadcrumbList","@id":"https:\/\/www.teamdesk.net\/blog\/whats-new\/power-bi-teamdesk-data-connector\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.teamdesk.net\/blog\/"},{"@type":"ListItem","position":2,"name":"Power BI + TeamDesk Data Connector"}]},{"@type":"WebSite","@id":"https:\/\/www.teamdesk.net\/blog\/#website","url":"https:\/\/www.teamdesk.net\/blog\/","name":"TeamDesk Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.teamdesk.net\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.teamdesk.net\/blog\/#\/schema\/person\/22c4c05bd657513c8b00122fa364c8d2","name":"Kirill Bondar","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/dc5bc844095b5753ccc73c589c028bf16615674f289668146bbd59205a08a52d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/dc5bc844095b5753ccc73c589c028bf16615674f289668146bbd59205a08a52d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/dc5bc844095b5753ccc73c589c028bf16615674f289668146bbd59205a08a52d?s=96&d=mm&r=g","caption":"Kirill Bondar"},"url":"https:\/\/www.teamdesk.net\/blog\/author\/kirill-bondar\/"}]}},"_links":{"self":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts\/1252","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/comments?post=1252"}],"version-history":[{"count":7,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts\/1252\/revisions"}],"predecessor-version":[{"id":1714,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts\/1252\/revisions\/1714"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/media\/1259"}],"wp:attachment":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/media?parent=1252"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/categories?post=1252"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/tags?post=1252"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}