Data model error when export data to Excel

[Anonymous]

Hello community,

When i want to export to excel a Power Bi table choosing summary data with dynamic connection like this

the generated excel shows the following error:

"Data could not be obtained from the data model (...) Error: Forbidden"

I can't export data this way either:

I have administrator role in this project, so I can't find a possible solution to this problem.

Thanks for the help!

[Anonymous · Accepted solution]

Hi @Anonymous 

Please refer to the following points:

1.Please check that do you have the 'build' permission of the dataset, only the user has the build permission, then he/she can export the data, you can refer to the following link.

Build permission for shared datasets - Power BI | Microsoft Learn

2.Check that the report has the Can aggregate data option turned on, if not,please open it in Power BI Desktop.

File > Options and Settings > Options > Current File > Report Settings > Export Data subtitle > “Allow End Users to Export Both Summarized and Underlying Data from the Service. 

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.