Error with visual.exportData()

[Lounes-Activops]

Hi, 

I think my issue is related to many other posts, but no answer provided yet. 

When i try to export data from a custom visual, in web side, using the power bi embedded api, i get this error : 

Hi team, I am getting below error, while  I am trying to export visual through PowerBi js 

{
"message": "ExportDataFailed",
"detailedMessage": "Error running visual data query",
"level": 3,
"technicalDetails": {
"errorInfo": undefined,
"requestId": undefined
}
}

The export function used to work before, but since three days, it's not workig at all. 

Could anybody help please ? it's quite urgent. 

Thank you in advance, 

Lounes  

[JPW]

@gto I posted a workaround on another related thread that seems to be working in our environment.  See if that resolves the issue for you.

[gto]

Hello,

Still facing the same issue. No details in the error message. Export works from the PBI Service but not from the JS API.

Export is within the limitations and stopped working in the last 2-3 weeks.

{
"message": "ExportDataFailed",
"detailedMessage": "Export visual data has failed",
"level": 3,
"technicalDetails": {}
}

Can anyone help? 

Thanks,

[stevenamani]

I can confirm that making the API call twice or thrice (immediately after it errors) is working. 

[JAnder]

I wonder if my export problems also relate to this. using the API and ExportToFileInGroupAsync, when I call GetExportToFileStatusInGroupWithHttpMessagesAsync I now consistently get a failure status. This worked previously and the code or report didn't change.

[V-lianl-msft]

Please try to remove groupId from the embed url or from the embed config when the report is in a workspace V2.

[alexmcarreira]

Same error occurs after testing without the groupId in the embedUrl in a V2 workspace

[JPW]

We started getting the same error yesterday afternoon (US Eastern time). 

The only workaround we found was to first manually export the data (clicking on the ellipsis on the table, then select "Export data" then export using any of the options).  After that triggering the code that has visual.exportData (in our case it's triggered by clicking a button) works.  It continues to work until the page is refreshed.

[csssoft]

We are experiencing this "ExportDataFailed" error too, all of a sudden! This is an all-systems-down business-critical issue for us. 

@V-lianl-msft Can you please help us to escalate this?

Thanks.

[AntonioCoelho]

We are experiencing a similar issue "Export visual data has failed" with no technical details.

[stevenamani]

We are also experiencing this same issue all of a sudden. Any responses from the folks at Power BI would be very useful!

[Versatile]

We're also experincing this issue, a partial workaround that helped was exporting non-summarized data (eg. using the Underlying export data option).

[V-lianl-msft]

Are you running into any of the known limitations based on the article here? - listed below

Limitations

• The maximum number of rows available to export is 30,000.
• Exports using Underlying do not work if the data source uses Analysis Services live connection on versions older than 2016, when the tables in the model do not have a unique key.
• Exports using Underlying do not work if Show items with no data is enabled for the visualization.
• If filters are applied to the visualization, the exported data will also be filtered.
• If using DirectQuery, the maximum amount of data that can be exported is 16 MB. Exports may result in less than the maximum number of rows, especially if when using multiple columns, data that is difficult to compress, or factors are present that increase file size and decrease number of rows exported.
• Power BI only supports export on visuals that use basic aggregates. Export is not available on visuals using model or report measures.
• Custom and R visuals, are not supported.
• Power BI admins have the ability to disable the export data feature.
• Concurrent export data requests from the same session are not supported. Multiple requests should be run synchronously.

[Lounes-Activops]

Hi V-Lianl-msft, 

Thank you for replying.

No, i'm not running over the limitations listed in your message. 

What i don't understand is, the export data function used to work correctly before las week.

The error i get from my javascript function is "ExportDataFailed". 

Thank you in advance for your advices. 

Lounes