Forum Discussion
Anonymous
2 years agoNot applicable
Connect Power Bi Semantic Model to external applications
I am looking for information if it is possible to create a pipeline that extracts certain data from a Power BI semantic model to external applications for example Benchling. The semantic model's...
- 1 year ago
Here is an API for querying a Power BI semantic model (aka dataset):
https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/execute-queries
(It uses DAX query code, which is a bit different syntax from what you would use in your typical DAX measures or calculated columns. DAX query is the same syntax as you would use in DAX Studio or DAX query view.
I think Performance Analyzer in Power BI Desktop can be helpful for generating DAX query code. The code generated only selects TOP N rows, you might consider altering that code so it doesn't include a TOP N filter.)
NandanHegde
Super User
2 years agoBased on my understanding, Data pipelines doesnt support Benchling as the sink.
But you can still extract the data from Power BI semantic model via data pipelines and API.