Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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...
Need Help
pipelines
  • frithjof_v's avatar
    frithjof_v
    2 years 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.)

frithjof_v's avatar
frithjof_v
Icon for Community Champion rankCommunity Champion
2 years 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.)