Publish a Dataset with API Data

Make sure that you have configured a system DSN associated with the connector and that the DSN succeeds when testing its connection. If you do not have a successfully configured system DSN, see Creating the Data Source Name for configuration help.

Then, create and publish a dataset as follows:

1. Open Power BI Desktop.
2. In the Home ribbon, navigate to Get Data > Other.
3. Scroll down the Other list until you find CData API.
4. Click CData API, then click Connect. PowerBI Gateway displays the CData API: Connector window.
5. In Data Source Name, specify the name of a API system DSN (the default system DSN is called "CData PBI API Sys"), then select Import mode and click OK. PowerBI Gateway displays the Navigator window. In the left pane are directories of available tables in the selected data source.
6. Click the folders to open them, then select your desired tables using the checkboxes beside their names.
7. Click Load. The selected data appears in the Data pane, at right.
8. Create a visualization.
9. When you are ready to publish, return to the Home ribbon.
10. Click Publish.
11. Sign in to your Power BI account, if prompted.
12. Name and save the .pbix file for the dataset. The chosen dataset name will be reflected on powerbi.com.
13. If prompted, sign in with the Power BI account associated with your Power BI Gateway installation.
14. Select the workspace you would like to publish the dataset to and click Select. Wait for the publication process to complete.