For this example integration, you'll need the Microsoft PowerBI Desktop app for Windows installed, and an active PowerBI subscription. You can also use recent versions of Microsoft Excel for Windows, with differences noted below.
This query script performs a few tasks: obtains an authorisation token using your API Key and Secret; uses that token to obtain a list of files and folders; and drills down into a specific folder to obtain the file list and file metadata inside. Comments are provided in the script itself.
Replace the text <Your API Key> and <Your API Secret> with the actual values from your account.
For security we do not recommended that you include your production API Key and Secret inside the script itself in a production environment.
This sample script uses the production API URL (https://public-api.tiqk.io). Any audits completed under your account via the public API URL will count towards your usage and may incur additional subscription fees. For development and testing we offer a sandbox API URL with test limits. Contact our Customer Success team using the Chat bubble for more information.
If there are no syntax errors detected, click the Done button.
Step 2: Authorise the data connection
You may be prompted with a data privacy message:
To keep this example simple, we will ignore the privacy settings for this connection. In a production environment you should select an appropriate setting to ensure that your users can access the data from the Power Query in a secure manner.
Step 3: Preview the live results
If successful, the query will execute and the results (in this case, a list of files uploaded to your TIQK account, and their meta data including any overall audit results) will be previewed:
Step 4: Close and apply the query
When ready, click Close & Apply on the toolbar to save the Query, and load the live results into the PowerBI file or Excel workbook for further analysis or visualisation in your custom dashboard:
To refresh the dashboard or Excel workbook with the latest data from the TIQK platform, choose the Home > Refresh (or Data > Refresh in Excel) button.