Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Lounes-Activops
New Member

Error with visual.exportData()

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  

13 REPLIES 13
JPW
New Member

@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
New Member

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
Advocate II
Advocate II

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

JAnder
Helper I
Helper I

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
Community Support
Community Support

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

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

JPW
New Member

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
Frequent Visitor

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
Advocate I
Advocate I

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

stevenamani
Advocate II
Advocate II

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

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
Community Support
Community Support

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.

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 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors