Docs portal

Power BI

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

Connect data.world to Microsoft Power BI.

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

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.
powerbi_connect.png

  1. Download Power BI Desktop.

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

  3. Configure your data, you'll need to enter the Owner, Dataset ID, and any desired queries, and click OK. Example: Using https://data.world/associatedpress/foreign-exchange-rates.

    • Owner: associatedpress

    • Dataset ID: foreign-exchange-rates

    • Query: SELECT * FROM quarterly

    powerbi_get-data.png

  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.

powerbi_edit-data.png
powerbi_chart.png

  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 data.world:

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

  • Configure a scheduled refresh for data.world 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..

In this section: