Import data into Power BI
You can use Power BI to build dashboards and analyse data using our API.
From the data tool, you can copy a link to an HTML table or JSON table format query for your data. In the Power BI Get data | Other | Web option, paste the link in the URL field and import it as a table.
These videos give simple instructions:
And these videos provide more detail: