Export selected data to an API from Power BI

samvaldez — Thu, 30 Jan 2020 14:34:26 GMT

Hi everyone!

I'm a newbie in PBI and I have this situation: the business area wants to export filtered data from a report in PBI to send this data to an APP through an API; I have tried so many ways, is there any way to do this?

Re: Export selected data to an API from Power BI

dm-p — Thu, 30 Jan 2020 23:30:57 GMT

Hi samvaldez,

The only way to programmatically export data from a Power BI dataset is using the XMLA endpoint - this is currently in preview (expected to be in GA by September) and is a premium feature, so won't be viable if you're using Pro.

To mimic exporting from a report, you'd need to apply the necessary filters and/or context via a suitable command over XMLA to get the desired result set before sending on to an external service.

There's also an idea for the feature you're specifically asking for, if you want to vote on it.

Not the answer you're hoping for, I know, but hopefully provides some further insight.

Regards,

Daniel

If my post solves your challenge, then please consider accepting as a solution to help other forum members find the answer more quickly 🙂

topic Export selected data to an API from Power BI in Developer

Export selected data to an API from Power BI

Re: Export selected data to an API from Power BI