Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
We have received feedback from users that they are having issues with exporting data (both summarized and underlying ) into excel. They are receiving the following error message:
"Error Exporting Data
Sorry, we couldn't export your visual data right now. Please try again later"
I, as well as another analyst, have been testing different reports and scenarios, and have come up with the following conclusions:
1. We are able to export summarized data in .csv format
2. We are able to export records in .csv format
3. We cannot export summarized data into excel
4. We cannot export underlying data into excel
This has not been an issue as of last week; I personally performed an export last week. We did notice that Microsoft included a new feature in the December release where users can set export options:
" Power BI report designers control the types of data export options that are available for their consumers. The choices are:
Allow export of only summarized data (this is the default for new reports)
Allow exporting of summarized and underlying data (this was the default prior to October 2018)
Don't allow exporting of any data
We selected the option to allow exporting of summarized and underlying data to 2 reports, republished to powerbi.com, republished the app, yet still had the same result of export not working.
Is anyone having this same issue?
Solved! Go to Solution.
Hello AGMTB0730,
I had the same problem 2 days ago. I opened a ticket to Microsoft yesterday, they solved the problem this morning. It's definitely a systemic error. No need to wait for the solution here.
PowerBI support https://powerbi.microsoft.com/en-us/support/pro/ticket/
I am having this issue: "Error Exporting Data. Sorry, we couldn't export your visual data right now. Please try again later." When trying to export my data. It works on some tabs I have on my report, but not on others.
@Anonymous,
I have made a test on this issue. In power bi desktop we could only export summarized data. However, after I published the report to power bi service. I could export summaried data successfully. Could you share more details?
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Jimmy,
I am also able to export summarized data from desktop, but it is only through .csv
Power BI service also allows to download the summary data through .csv format, but not excel (xlsx) format. Also cannot download underlying data using excel (.xlsx) format.
Hello AGMTB0730,
I had the same problem 2 days ago. I opened a ticket to Microsoft yesterday, they solved the problem this morning. It's definitely a systemic error. No need to wait for the solution here.
PowerBI support https://powerbi.microsoft.com/en-us/support/pro/ticket/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |