Forum Discussion
Exporting data from a standard PowerBI Visual to an external API
Hi developmenttend,
In terms of core functionality you can't automate the export of data from within Power BI reports in the way you're proposing.
- You can manually export the data from a visual using the options in the visual header, if your administrator has permitted it.
- If you're on premium, you could write an integration outside of Power BI that generates a query using the XMLA endpoint and then sends it on somewhere else.
Visuals can't talk to other visuals. They also don't have access to the data model - the data is pushed into the visual from Power BI based on the combination of fields/measures in the properties pane.
While cross-filtering and slicing has the appearance that a visual is affecting others, any such operations are requests from the visual to the main window via an API to request that it filter other visuals on its behalf and Power BI will delegate to other visuals based on their interactions.
You can write a custom visual that can export its own data to an endpoint but this endpoint needs to allow requests from any domain as a custom visual is a sandboxed iframe with very limited functionality. But in short, this is still within its own particular context and can't reach outside itself to other visuals.
Regards,
Daniel