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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
samvaldez
Regular Visitor

Export selected data to an API from Power BI

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?

1 REPLY 1
dm-p
Super User
Super User

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 🙂





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


My course: Introduction to Developing Power BI Visuals


On how to ask a technical question, if you really want an answer (courtesy of SQLBI)




Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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