Export selected data to an API from Power BI

[samvaldez]

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?

[dm-p]

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 🙂