Microsoft Power BI now includes certified connector for TeamDesk.
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.
