Power BI Service

Hello Rosy081 

If a report is based on a dataset located in a different workspace, downloading the report is not supported. This is a known limitation of Power BI Service

here are few things which yiu can do as workaround:

• Move or duplicate the dataset into the same workspace as the report:
  • Download the dataset’s .pbix file from its current workspace.
  • Publish it to the workspace containing the report.

If separating datasets and reports across workspaces is necessary, consider using linked datasets or creating a master workspace that houses both datasets and reports for easier management

If this is helpful , please accept the solution

https://community.fabric.microsoft.com/t5/Desktop/Moved-Reports-and-can-no-longer-download-them/td-p/2403470

https://community.fabric.microsoft.com/t5/Service/Inability-to-see-the-download-option-in-Power-BI-service/m-p/2190532

Hi Rosy081 

When a Power BI report and its dataset are in the same workspace, downloading the report works seamlessly. However, once the dataset and report are split into different workspaces, the download report option is disabled due to Power BI's security and workspace management settings.

To enable report downloads in this scenario, ensure that you have Build permissions on the dataset in the source workspace. Additionally, check if the dataset is certified or promoted, as this can sometimes impact report access settings. If you are using Power BI Service (not Power BI Desktop), another workaround is to recreate the report in Power BI Desktop by connecting to the dataset via the Power BI Dataset Connector and then republishing it. Lastly, confirm that Export and Download settings in the Power BI Admin portal allow downloading reports with live connections.

Hi Rosy081, 

Thank you for reaching out to the Microsoft Forum Community.

I wanted to check if you had the opportunity to review the information provided nilendraFabric & rohit1991.

Please feel free to contact us if you have any further questions. If the responses provided has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

Hi Rosy081 

In Power BI, when a report and its dataset (semantic model) are in the same workspace, you can easily download the report as a .pbix file. However, when the dataset and report are in different workspaces, the download report option gets disabled due to Power BI’s security and governance policies. This happens because the report is now considered a thin report that connects to a dataset residing in another workspace. To enable downloading, you need to ensure that both the dataset and report are in a workspace where you have Build permissions on the dataset. Additionally, if the dataset resides in a Premium workspace, check that the “Allow report viewers to export data” option is enabled in the dataset settings. As a workaround, you can manually recreate the report by connecting to the shared dataset from Power BI Desktop and republishing it. However, Power BI does not currently allow direct download of thin reports from the service when the dataset is in a separate workspace.

Hi Rosy081 One of the prerequisites to download report is Contributor permission to the workspace. Double check your permission. 

Hi Rosy081,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

Hi Rosy081,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

Hi Rosy081,

We haven’t heard back from you regarding your issue. If it has been resolved, please mark the helpful response as the solution and give a ‘Kudos’ to assist others. If you still need support, let us know.

Thank you.