This document provides instructions for updating Power BI datasets with an API key to secure report results and data from tables. The steps include copying a new data URL in Anker, creating a new data set or updating an existing one in Power BI, and generating an API key in Anker. Screenshots and code examples are provided to illustrate the process.

Copy a new data URL in Anker


If you don’t have an existing report in PowerBI, you can find exposed API links in two places in Anker:

  1. In tables:

Untitled

  1. Report link in validation view:

Untitled

Create a new dataset in PowerBI


  1. Select Web in Get data dropdown:

Untitled

  1. In Advance settings, insert the API link of table or validation, then below insert your API key (see) under a X-Anker-Api-Key header parameter and click OK.

Untitled

Update an existing dataset in PowerBI


  1. In a Data panel, right-click on your existing data set and select Edit query: