topic Re: Export Data from Visual in Developer

Export Data from Visual

stevenamani — Mon, 16 Jul 2018 17:06:16 GMT

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?

Re: Export Data from Visual

v-jiascu-msft — Tue, 17 Jul 2018 09:01:03 GMT

Hi @stevenamani,

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

Best Regards,

Dale

Re: Export Data from Visual

stevenamani — Tue, 17 Jul 2018 17:08:24 GMT

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.