Publish a Semantic Model with Microsoft Excel Online 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 semantic model 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 Microsoft Excel Online.
4. Click CData Microsoft Excel Online, then click Connect. PowerBI Gateway displays the CData Microsoft Excel Online: Connector window.
5. In Data Source Name, specify the name of a Microsoft Excel Online system DSN (the default system DSN is called "CData PBI ExcelOnline 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 semantic model. The chosen semantic model 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 semantic model to and click Select. Wait for the publication process to complete.