Skip to main content

Power BI

Microsoft Power BI gives you a powerful platform to analyze, manipulate, and visualize your data..

Connect to Microsoft Power BI.

Using the connector from Power BI desktop, you can easily retrieve data from

Please note that Microsoft Power BI is currently available only on Windows. You'll need to be running a Windows OS or a virtual machine on your Mac OS.
  1. Download Power BI Desktop.

  2. Open Power BI and choose Get Data, then select and connect.

  3. Configure your data, you'll need to enter the Owner, Dataset ID, and any desired queries, and click OK. Example: Using

    • Owner: associatedpress

    • Dataset ID: foreign-exchange-rates

    • Query: SELECT * FROM quarterly

  4. Log in with either your API token (from dataworld advanced settings) or using OAuth sign-in.

Preview and refine your data.

Preview your data and use the query editor to apply any desired changes before loading data into Microsoft Power BI.

  1. When your data preview appears, click Edit to make any changes to your query. You can now make changes including removing rows & columns, merging queries, grouping data, and more.

  2. When you're satisfied with your query, select Close & Apply from the top left corner of your window.

  3. Start creating reports!

What next?

Here are a few things you can do with Microsoft Power BI and

  • Publish your report to the Power BI community, embed it into your website, or share it back to using the Power BI report URL.

  • Configure a scheduled refresh for queries so they're always up to date.

  • Customize your queries to make them ideal for analytics, including pivoting or un-pivoting the data, adding date calculations, and more..