Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Is there any way to programatically access data that has been transformed by Power BI to display in our own custom application?
I see this forum question (Get data using REST API) from February early this year (2017) and was curious if there were other options, if any headway has been made to fulfill that feature, or if I'm just straight out of luck.
Solved! Go to Solution.
@willyt150 wrote:
That is correct. We'd like to make use of Power BI's abilities for polling and transforming the data and then use and display that information within our application without being required to display that data with Power BI visuals.
So far it is not possible, as I suggested, you can vote this idea REST API access to READ datasets up.
By the way, I do think there're various ways(eg. SQL Server Integration Service and other similar ETL tool, or even pure SQL if your data resides in databases, or through some dev language Google tells more) to pool and transform data besides Power BI.
You want Power BI Embedded:
https://azure.microsoft.com/en-us/services/power-bi-embedded/
Thanks, but unless I'm missing something the only way I see to get at the actual transformed data is by embedding Dashboards, Reports, or Tiles.
The API appears to give access to almost everything except the actual data.
Ah, I may have misunderstood your need. It sounds like you want to take the transformed data and then USE it in some way within the application, not just display that information within the application, is that correct?
That is correct. We'd like to make use of Power BI's abilities for polling and transforming the data and then use and display that information within our application without being required to display that data with Power BI visuals.
@willyt150 wrote:
That is correct. We'd like to make use of Power BI's abilities for polling and transforming the data and then use and display that information within our application without being required to display that data with Power BI visuals.
So far it is not possible, as I suggested, you can vote this idea REST API access to READ datasets up.
By the way, I do think there're various ways(eg. SQL Server Integration Service and other similar ETL tool, or even pure SQL if your data resides in databases, or through some dev language Google tells more) to pool and transform data besides Power BI.
Bummer, but thank you very much for answering
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
4 | |
4 | |
3 | |
3 | |
3 |