Publish datasets and reports from Power BI Desktop

When you publish a Power BI Desktop file to the Power BI service, you publish the data in the model to your Power BI workspace. The same is true for any reports you created in Report view. You’ll see a new dataset with the same name, and any reports in your Workspace navigator.

Publishing from Power BI Desktop has the same effect as using Get Data in Power BI to connect to and upload a Power BI Desktop file.

Note

Any changes you make to the report in Power BI won't be saved back to the original Power BI Desktop file. This includes when you add, delete, or change visualizations in reports.

To publish a Power BI Desktop dataset and reports

  1. In Power BI Desktop, choose File > Publish > Publish to Power BI or select Publish on the ribbon.

    Publish button

  2. Sign in to Power BI, if you aren't already signed in.

  3. Select the destination. Beginning with the September 2020 release, you can search your list of available workspaces to find the workspace into which you want to publish. The search box lets you filter your workspaces. Select the workspace, and then click the Select button to publish.

    Select publish destination

When publishing is complete, you receive a link to your report. Select the link to open the report in your Power BI site.

Publish success dialog

Republish or replace a dataset published from Power BI Desktop

The dataset, and any reports you created in Power BI Desktop, upload to your Power BI site when you publish a Power BI Desktop file. When you republish your Power BI Desktop file, the dataset in your Power BI site is replaced with the updated dataset from the Power BI Desktop file.

This process is straightforward, but there are a few things you should know:

  • Two or more datasets in Power BI with the same name as the Power BI Desktop file could cause publishing to fail. Make sure you have only one dataset in Power BI with the same name. You can also rename the file and publish, creating a new dataset with same name as the file.

  • If you rename or delete a column or measure, any visualizations you already have in Power BI with that field could be broken.

  • Power BI ignores some format changes of existing columns. For example, if you change a column’s format from 0.25% to 25%.

  • Say you have a refresh schedule that is configured for your existing dataset in Power BI. When you add new data sources to your file and then republish, you’ll have to sign into them before the next scheduled refresh.

  • When you republish a dataset published from Power BI Desktop and have a refresh schedule defined, a dataset refresh is started as soon as you republish.

  • When you make a change to a dataset and then republish it, a message shows you how many workspaces, reports, and dashboards are potentially impacted by the change, and asks you to confirm that you want to replace the currently published dataset with the one you modified. The message also provides a link to the full dataset impact analysis in the Power BI service, where you can see more information and take action to mitigate the risks of your change.

    Warning about impact of republishing a dataset

    Learn more about Dataset impact analysis.

Note

Some data connection in Power BI reports may include links to data, rather than including the data in the dataset that's imported into the Power BI service. For example, DirectQuery connections link to data as updates or interactions occur, rather than importing the data itself. If linked data sources in your report are on premises, you may need a gateway to access them from Power BI. For more information, see what is an on-premises data gateway?.

Next steps

You can do all sorts of things with Power BI Desktop. For more information on its capabilities, check out the following resources: