ExportDataFailed Error from Embed API

[stevenamani]

I have seen others post this issue with no response so here is hoping that this will increase the noise on this issue. It is extremely critical and urgent for us.

We have been using the visual.exportData method for a couple of years to export summary or underlying data from Power BI visuals. All of a sudden this is no longer working with a very ambiguous error message:

error = {message: 'ExportDataFailed', detailedMessage: 'Export visual data has failed', errorCode: undefined, level: 3, technicalDetails:{

errorInfo: undefined

requestId: undefined
}}

The issue seems to only be affecting table and matrix visuals.

We are using the latest v2.18.7 javascript client version

[kwyoung001]

We use a 3rd party tool to export data from PBI and they said MS has an issue 

We have recently been aware of an issue affecting some customers where Power BI reports exported to data formats such as MS Excel - Data Only or CSV fail with a “Could not read data back from Power BI” error.

The error is caused by the visual.exportData() API call to Power BI. Unfortunately, the error returned by Power BI is completely unhelpful.

[csssoft]

It is affecting all visual types 😕

[v-robertq-msft]

Hi,

According to my test, I can normally export the data of table or matrix to Excel and CSV with the current layout or summarized type in the Power BI service, would you like to post a download link of the pbix file with this issue without the sensitive data if it’s possible and we can help you to check if it’s an existing issue in the Power BI?

I also suggest you to make sure you have updated to the latest version of the Power BI desktop.

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

[stevenamani]

Here is a sample PBIX having the issue. Try exporting the Features Matrix visual using summary. We have been able to export this visual in the past and this PBIX is not new

https://we.tl/t-PYNbjfDvp8

[csssoft]

As stated, the problem is an error that occurs when using the API to export. It is not a problem when you load a report and export manually from Power BI service. It happens on all reports with all visual types, and there is no relation to Power BI desktop. These reports have been exporting without issues for months and the reports have not changed between Thursday and Friday when the errors started happening. The issue has been reported by many of our customers in the US, Europe, Asia and Australia. This is a priority 1 urgent situation. @v-robertq-msft Can you please escalate this? 

[sa-]

We are suffering from the same problem too, since friday. The problem is related to the use of the exportData via the js API. What we noticed, is that if you pass the call a second time it works. Please could you investiguate this and solve it ASAP. All our reports are down because we rely on this api to prefill our portal with data sourced from the report. 

[v-robertq-msft]

Hi @stevenamani ,

According to your test pbix file, I can still successfully export the Features matrix to CSV in the Power BI desktop:

It’s better if you can post a video that shows the reproducing precedure of your exporting issue so that we can help you to make sure if this is an issue in the Power BI.

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

[sa-]

@v-robertq-msft : the problem is in the api, not in the GUI interface. 

for example in my report I try to export the data using visual.exportData() of a visual called "version" and I get the following error:

the second execution, and using the same snippet of code I get a good result:

for this experiment I used power bi js library playground (https://playground.powerbi.com/fr-fr/dev-sandbox)

[stevenamani]

Here is a video of the issue using the dev playground (https://playground.powerbi.com/en-us/dev-sandbox)

https://we.tl/t-eMxx0AvB6M

Let me know if you have more questions

[v-robertq-msft]

Hi,

According to my research, a similar issue has been reported internally, so stay tuned.

Issue description: Unable to export Summarized data for the Matrix visual with an error

ICM: 275173415

I will update here once I get any information.

Thank you very much!

Best Regards,

Community Support Team _Robert Qin