Forum Discussion
Export underlying data not available to end users while export setting is correct
- 6 years ago
Hi , KrisB2019
Can end user export the summarized data?
And please recheck the this two points:
1.make sure the end user have the dataset "build " permission , not dashboard or report permission
2.make sure that Power BI admins didn’t disable the function of "export of data" for some groups
If you still have this issue for Power BI, you can create a support ticket in Power BI Support to get further help and better advice.
Best Regards,
Community Support Team _ Eason
Hi, KrisB2019
Have you checked the report settings for the service as shown in this picture?
For more details and limitations , please referto this article.
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- KrisB20196 years agoFrequent Visitor
Thanks v-easonf-msft, the only one of those I do not have access to is the admin portal because I'm not set up as the admin. However, my end users are able to export from other reports/dashboards I've created. I did verify in the online service settings that export summarized and underlying was selected for my report. It is also selected in the BI desktop file under options. Yesterday, I took a report that was exporting data correctly, made some modifications so it matched my problem report, published it and had the end user try it. He experienced the same issue. I got him to screenshare again and walk me through step-by-step what he was doing. He accessed the newly created report and when exporting, underlying data was grayed out. Then he accessed the report that was working (the one to which I had made modifications) and he could still export the underlying data. I am absolutely stumped because none of it makes sense and my report used to work. My next steps today are to have users for whom this report previously worked try it again, so I can see if this is limited to the ones with the newest access or if it is widespread. They all have the same permissions in BI, so it shouldn't be any different, but I'm not sure what else to do. If you have any other suggestions, I'm open to them. Thanks again!
- v-easonf-msft6 years agoCommunity Support
Hi , KrisB2019
Can end user export the summarized data?
And please recheck the this two points:
1.make sure the end user have the dataset "build " permission , not dashboard or report permission
2.make sure that Power BI admins didn’t disable the function of "export of data" for some groups
If you still have this issue for Power BI, you can create a support ticket in Power BI Support to get further help and better advice.
Best Regards,
Community Support Team _ Eason- KrisB20196 years agoFrequent Visitor
You were absolutely right v-easonf-msft, it was #1! When I shared with the end users, I did not have it set up so the end user had the "build" permission. I've reshared with that permission built in and it works. I can't believe it was something so simple and really appreciate your help.
Thanks again!