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:
- Download a report as a .pbix file. Depending on the configuration, this file might include a dataset.
- Download 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. You can download the report in Reading view or 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 when 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 that the report is in. If the report is based on a dataset in another workspace, you need to be at least a Contributor to that workspace as well.
- You can't download reports created using the Create button in the Power BI service that are based on a dataset in another workspace.
- Reports created in Power BI Desktop must have been published or uploaded to the Power BI service before you can download them.
- If you create a report in the Power BI service, you have to save it before you can download it.
- You can't download reports based on datasets that are imported from Onedrive for Business.
- The report you're downloading must be published or updated after November 23, 2016. Reports published earlier aren't downloadable.
- You can't download the eight original built-in sample .pbix files from the Power BI service. However, you can download those same .pbix files from the Power BI samples article.
- 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 when 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.
- You can't download datasets based on data imported from Onedrive for Business.
- Downloading a .pbix file that is larger than 1 GB isn't supported.
- Datasets with automatic aggregations enabled can't be downloaded to a .pbix file.
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
Maklum balas
Kirim dan lihat maklum balas untuk