Forum Discussion
Data model error when export data to Excel
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.
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.