Download a report from the Power BI service to Power BI Desktop
APPLIES TO: ✔️ Power BI Desktop ✔️ Power BI service
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. This article explains how to download a report or a dataset from the Power BI service to Power BI Desktop. The extension for a Power BI file, in either case, is .pbix.
There are two ways to download a .pbix file, each with different results and considerations:
- Downloading a report as a .pbix file. Depending on the configuration, this file might include a dataset.
- Downloading a .pbix file from a dataset.
Prerequisites
- To download a .pbix file, you at least must be a Contributor to the workspace.
Download a report as a .pbix file
To download a report as a .pbix file, follow these steps:
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.
From the top menu bar, select File > Download this file.
If this option isn't shown or is disabled, you're likely trying to download a .pbix in a scenario listed under Limitations later in this article.
While the report is downloading, a status banner displays the progress. The default name of the file matches the title of the report.
If you haven't already, install Power BI Desktop, and open the .pbix file in Power BI Desktop.
Download a .pbix file from a dataset
To download a dataset as a .pbix file, follow these steps:
In the Power BI service, open the workspace content view:
Find the dataset you want to export and select the More options button:
In the menu, select Download this file, if it's available:
If this option isn't shown, you are likely trying to download a .pbix in a scenario listed under Limitations later in this article.
While the report is downloading, a status banner displays the progress. The default name of the file matches the title of the report.
If you haven't already, install Power BI Desktop, and open the .pbix file in Power BI Desktop.
Considerations
- 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 can't open downloaded .pbix files using a Power BI Desktop version that doesn't support information protection.
- If your administrator has turned off the ability to download data, this feature won't be visible in the Power BI service.
- If you download the same .pbix file multiple times, the SecurityBindings file section in the .pbix file changes each time. This is by design.
Limitations
This section lists the limitations of downloading a .pbix file. This section is split into two parts:
- Limitations when downloading a .pbix file from a report.
- Limitations when downloading a .pbix file from a dataset.
Limitations downloading a .pbix from a report
- You can download a file in either Reading view or Editing view. You must be at least a Contributor to the workspace.
- Reports created in Power BI Desktop must have been published or uploaded to the Power BI service before they can be downloaded.
- Reports created in the Power BI service must be saved before they can be downloaded.
- The report you're downloading must be published or updated after November 23, 2016. Reports published earlier aren't downloadable.
- You can't download reports and the built-in downloadable samples originally created in the Power BI service, unless the report was created through the quick create experience.
- Usage metric reports can't be downloaded to a .pbix file.
- You can only download the original report. You can't download a copy of a report.
- If you download a live connection report (connected to SSAS or AAS) after you change its data source by using REST APIs Update Datasources or Update Datasources In Group, the downloaded .pbix will still contain the old data source.
- You can't download reports created in the Power BI service that are based on a single dataset that is configured for large models, incremental refresh, or has been modified by using the XMLA endpoint.
- If you create a Power BI report based on a dataset in one workspace and publish the report to a different workspace, you can't download the report if the dataset is configured for large models, incremental refresh, or has been modified by using the XMLA endpoint.
Limitations downloading a .pbix from a dataset
- To download the .pbix file, you must be at least a Contributor to the workspace.
- Datasets with incremental refresh can't be downloaded to a .pbix file.
- Datasets enabled for large models can't be downloaded to a .pbix file.
- Downloading a .pbix file after deployment isn't supported as part of the deployment pipeline (ALM).
- Datasets modified by using the XMLA endpoint can't be downloaded to a .pbix file.
- Downloading a .pbix file that is larger than 1 GB isn't supported.
Parity between Power BI Desktop and the service
When you open a .pbix file in Power BI Desktop, you may see a warning message that some features available in the Power BI service aren't available in Power BI Desktop.
If you need to see the latest version that you worked on in the Power BI service (app.powerbi.com), you need to view the report there.
Working offline
Say you're working in Power BI Desktop without an internet connection and you open a report with an AppSource Power BI visual. If you hadn't previously saved the report while Power BI Desktop was online, the visual won't render. To fix this problem, follow these steps:
Make sure you're working online.
Open the report in Power BI Desktop. If your connection was reestablished after you opened the report, close the report and reopen it.
Save the report. After you've saved the report, you can open it again without an internet connection, and the Power BI visual will work.
Next steps
Povratne informacije
Pošalјite i prikažite povratne informacije za