Forum Discussion
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 primary source is an SQL database.
Thanks in advance
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.)
3 Replies
frithjof_vCommunity Champion
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
Based 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.
Houston-hoAdvocate I
If the destination support API, you could use web activity in a pipeline to do so, Web activity - Microsoft Fabric | Microsoft Learn
In case that doesn't provide API, and you could manually upload file dataset there, the final approach is Power Automate Robotic Process Automation, that mimic human mouse and keystroke like how you operate that web application. Browser automation actions reference - Power Automate | Microsoft Learn
