Forum Discussion
Can no longer export data from a visual when editing a report, nor after it has been saved
- 1 year ago
ibarrau wrote:Hi. I can't find the exact text at the docs but yeah, you can't export something you have just draged and dropped. You must save it first.
That is because since Power BI's creation up to earlier this week you could do that, and Microsoft just changed that without saying a word.
Hi. You can prevent excel export from 3 places. One would be the tenant settings and the org like you are saying. However, you should look at the last two checks of the export setting:
If you have one of those, then the workspace admin can prevent it even if it's allowed for the whole organization.
Another way of preventing the export it's from the "report setting". You can disable the setting for specific report. In order to validate this you can try export at a different report in the workspace or outside the workspace. That way you could validate which setting is the one prevent you to export.
I hope that helps,
Export is enabled everywhere you mentioned. Still we can't export data on a visual in a report while it is being created, while just last week it was possible.
- ibarrau1 year ago
Super User
Ok. If everything is turned on. Then you should deep dive in the scenario. There might be a consideration that's breaking the possibility. Read the limitations: https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data?tabs=powerbi-service#considerations-and-limitations
I hope that helps,
- dlopesc041 year ago
Resolver II
Could you go to the service right now, create a blank report connected to a semantic model, just add a table to it and a random field, select more aptions and try to click export data?
If you are able can you screenshot it?- ibarrau1 year ago
Super User
Hi. I can't find the exact text at the docs but yeah, you can't export something you have just draged and dropped. You must save it first. Then you can remove it and save back again if you didn't want to keep it. If you just want to export on demand columns, the datasets have a Table feature for that. When you open a dataset you don't need to edit them, you can pick columns, build a table and export.
https://learn.microsoft.com/en-us/power-bi/connect-data/service-dataset-details-page#data-previewI hope that helps,