Export Data from Visual

[stevenamani]

I am using the powerbi-client javascript library and working on exporting the underlying data behind a visual. In the 'rendered' event, I can successfuly pull the data and can inspect it in Chrome's debug console.

The problem I have however is that if I write the data to the page just using 'document.write(data)', the result doesn't seem to have any carrige returns or line feeds which are necessary to read into something like Excel. 

Is there a way around this?

[v-jiascu-msft]

Hi @stevenamani,

Did you try the demo here? And the source code? You can export a JSON type data. 

Best Regards,

Dale

[stevenamani]

I followed their example on the showcase page:

visuals[i].exportData(models.ExportDataType.Underlying)
.then(function (result) {
console.log(result.data);
})
.catch(function (errors) {
console.log(errors);
});

The result.data is just a long string and result has no other properties. Not sure how I would get JSON from this object.