Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

swathiarun63

Can't export to Power BI Desktop format

Submitted by on ‎09-07-2022 06:29 AM

swathiarun63_0-1662557253875.png

Cannot download power bi file from service

There is a issue with downloading the file. We are not using incremental refresh or large dataset storage.

Status: Investigating

Hi @swathiarun63,

 

In addition to incremental refresh and large dataset format, Power BI puts many other considerations and limitations on downloading your report to pbix file. Normally, your download issue is caused by one of these items. Please check them firstly and see whether there is any point applicable to you. Thanks in advance!

 

Limitations when downloading a report .pbix file

  • 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.
  • If you create a report using the Create button in the Power BI service, and it's based on a dataset in another workspace, you can't download it.
  • If you create a report using the Create button in one workspace in the Power BI service and then save it to a different workspace, you can't download it.
  • 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.
  • You can't download reports based on local Excel or CSV files that were uploaded to Power BI.
  • 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.
  • Downloading a .pbix file after deployment isn't supported as part of the deployment pipeline (ALM).

 

Limitations when downloading a dataset .pbix file

  • 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. You must disable automatic aggregations training in the dataset settings and delete the aggregations tables by selecting the checkbox Delete automatic aggregations tables.

 

Best Regards,

Community Support Team _ Caiyun

See more ideas labeled with:
1 Comment (1 New)
Comments
v-cazheng-msft
Community Support
Community Support
‎09-07-2022 07:57 PM
Status changed to: Investigating

Hi @swathiarun63,

 

In addition to incremental refresh and large dataset format, Power BI puts many other considerations and limitations on downloading your report to pbix file. Normally, your download issue is caused by one of these items. Please check them firstly and see whether there is any point applicable to you. Thanks in advance!

 

Limitations when downloading a report .pbix file

  • 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.
  • If you create a report using the Create button in the Power BI service, and it's based on a dataset in another workspace, you can't download it.
  • If you create a report using the Create button in one workspace in the Power BI service and then save it to a different workspace, you can't download it.
  • 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.
  • You can't download reports based on local Excel or CSV files that were uploaded to Power BI.
  • 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.
  • Downloading a .pbix file after deployment isn't supported as part of the deployment pipeline (ALM).

 

Limitations when downloading a dataset .pbix file

  • 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. You must disable automatic aggregations training in the dataset settings and delete the aggregations tables by selecting the checkbox Delete automatic aggregations tables.

 

Best Regards,

Community Support Team _ Caiyun

Idea Statuses