topic Re: Error with visual.exportData() in Developer

Error with visual.exportData()

Lounes-Activops — Wed, 10 Nov 2021 16:57:23 GMT

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

Re: Error with visual.exportData()

V-lianl-msft — Mon, 15 Nov 2021 05:42:25 GMT

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.

Re: Error with visual.exportData()

Lounes-Activops — Mon, 15 Nov 2021 08:45:53 GMT

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

Re: Error with visual.exportData()

stevenamani — Fri, 17 Dec 2021 09:52:22 GMT

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

Re: Error with visual.exportData()

AntonioCoelho — Fri, 17 Dec 2021 14:07:52 GMT

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

Re: Error with visual.exportData()

csssoft — Fri, 17 Dec 2021 14:52:32 GMT

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.

Re: Error with visual.exportData()

JPW — Fri, 17 Dec 2021 15:42:38 GMT

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.

Re: Error with visual.exportData()

Versatile — Fri, 17 Dec 2021 18:42:34 GMT

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

Re: Error with visual.exportData()

V-lianl-msft — Wed, 22 Dec 2021 06:20:47 GMT

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

Re: Error with visual.exportData()

alexmcarreira — Wed, 22 Dec 2021 09:21:21 GMT

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

Re: Error with visual.exportData()

JAnder — Wed, 22 Dec 2021 09:25:21 GMT

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.

Re: Error with visual.exportData()

stevenamani — Wed, 22 Dec 2021 12:29:36 GMT

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

Re: Error with visual.exportData()

gto — Sun, 16 Jan 2022 09:43:20 GMT

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,

Re: Error with visual.exportData()

JPW — Sun, 16 Jan 2022 14:40:19 GMT

@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.