Download a report from the Power BI service to Power BI Desktop

In Power BI Desktop, you can publish a report from your local computer to the Power BI service. Power BI reports can go the other direction as well, you can download a report from the Power BI service to Power BI Desktop. The extension for a Power BI report file, in either case, is PBIX.

A screenshot of the file menu in the Power B I service, with the download a P B I X file option highlighted.

Requirements

Always use the latest version of Power BI Desktop when you open downloaded files. Downloaded PBIX files might not open in non-current versions of Power BI Desktop. For example, you cannot open downloaded PBIX files using a Power BI Desktop version that does not support information protection.

  • You can download a file in either Reading view or Editing view, but you must have edit access to the report.

  • The report must have been created using Power BI Desktop and published or uploaded to the Power BI service.

  • The report you're downloading must be published or updated after November 23, 2016. Reports published earlier aren't downloadable.

Download the report as a PBIX file

To download the .pbix file, follow these steps:

  1. In the Power BI service, open the report you want to download.

    Note

    You can download the report in Reading view or Editing view. The image in this procedure is in Editing view.

  2. From the top nav pane, select File > Download report (Preview).

    A screenshot of the File menu in the Power B I service, with the Download report option highlighted.

  3. While the report is downloading, a status banner displays the progress. When the file is ready, you're asked where to save the PBIX file. The default name of the file matches the title of the report.

  4. If you haven't already, install Power BI Desktop, and open the PBIX file in Power BI Desktop.

Report feature parity

When you open a report in Power BI Desktop, you may see a warning message letting you know that some features available in the Power BI service report aren't available in Power BI Desktop.

A screenshot of a Power B I desktop Warning dialog box titled: Report layout differences might exist.

Working offline

When working in Power BI Desktop without an internet connection, if you open a report with an AppSource Power BI visual that wasn't previously saved while Power BI Desktop was online, the visual will not render. To fix this problem, follow these steps:

  1. Make sure you're working online.

  2. Open the report in Power BI Desktop. If you're connection was reestablished after the report was opened, close the report and reopen it.

  3. Save the report. After the report is saved, when you open it again without an internet connection, the Power BI visual will work.

Considerations and limitations

This section lists the limitations of downloading a PBIX file.

  • This feature won't work with reports and the built-in downloadable samples originally created in the Power BI service, unless the report was created through the quick create experience.

  • Reports created in the Power BI service must be saved before they can be downloaded.

  • If your administrator has turned off the ability to download data, this feature won't be visible in the Power BI service.

  • Datasets with incremental refresh can't be downloaded to a PBIX file.

  • Datasets enabled for large models and the reports created from these datasets can't be downloaded to a PBIX file.

  • Downloading a PBIX file after deployment isn't supported as part of the deployment pipeline (ALM).

  • Usage metric reports can't be downloaded to a PBIX file.

  • Datasets modified by using the XMLA endpoint can't be downloaded to a PBIX file.

  • If you create a Power BI report based on a dataset in one workspace and publish to a different workspace, you and your users won't be able to download it. The download feature is not supported in this scenario.

  • You can only download the original report. You can't download a copy of a report.

Next steps