Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
TeamDesk Data Connector for Microsoft Power BI (beta)
** This is beta technology currently supported on Microsoft Power BI Desktop only. **


* 01/22/18 Eliminated duplicate requests, improved performance
* 07/31/17 Fix timestamp column handling, improved data extraction speed
* 07/26/17 Initial Release

If you want to try it, follow this steps:

* Install Microsoft Power BI Desktop;
* Create a [My Documents]\Power BI Desktop\Custom Connectors directory;
* Download TeamDesk.PowerBI.DataConnector.mez into the directory. If browser tries to change file extension to .zip, rename it back to TeamDesk.PowerBI.DataConnector.mez;
* Enable Custom data connectors feature under File > Options and Settings > Options > Preview features in Power BI Desktop;
* Restart Power BI Desktop.

Upon using Get Data, you’ll find TeamDesk connector in Online Services category.

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.

Next, enter your TeamDesk email and password.

Next, connector will prompt you to choose the table and the view to get the data from.

Finally, click Load button to get the data to Power BI.

If you prefer programmability, there are two functions available at your disposal:

TeamDesk.SelectView(url, table, view) – given database URL, the name of the table and the name of view retrieves the content. This functionality is identical to the user interface connector provides.

TeamDesk.Select(url, table, columns, filter, sort) - allows you to specify the data you need, precisely. For example:

=TeamDesk.Select("https://www.teamdesk.net/secure/db/55214", "Invoice", {"Name", "Total"}, "[Company]='ABC, Inc.'", "Due Date//DESC")
selects customer names and totals from invoices for ABC, Inc. company, and sorts by recent due date on top.

Here is the link to blog article with screenshots:
Date Created
7/26/2017 5:43:48 AM
Date Updated
4/23/2018 4:18:45 AM
Was this information helpful?
Back to Search Results