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.
Hi all,
we are still a bit new to PowerBI and integrations, but what we want is actually pretty straightforward, but we weren't able to
get a decent starting point just by googling.
Imagine you have a report with some filterable data. And you want to open this data in an external application.
We were wondering if there was some way to export this data with just a click of a button. We were thinking about
some way to create a button which uploads the currently visible data from a given visual via ajax to some API we build
for that purpose.
Is this possible, and what's a good starting point to read into this stuff?
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.
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
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)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
2 | |
2 | |
1 | |
1 |