Execute Queries via API using Fabric

[sachitmurarka]

I have a Semantic Model in the Fabric , Just like we have executeQuery API in PowerBI , I am looking for Library methods/API end points to pass DAX query and call API to get output of table in form of rows. 

I have worked on similar requirement in PowerBI but in Fabric not able to find the exact API / Library which will work for this. Pls help

[v-jingzhan-msft]

Hi @sachitmurarka 

Currently, the Fabric REST API does not have a similar API to provide this functionality. 

Direct Lake mode relies on caching columns of data in memory, which is different from the full data import of the import mode and the real-time querying of the DirectQuery mode. Therefore, many Power BI REST APIs may not be suitable for this type of memory management.

As Microsoft continues to improve and expand the Fabric platform, we can expect more APIs to be introduced, providing a wider range of functionalities and greater flexibility. If you have specific feature requests or suggestions, you can submit them at Fabric Ideas Forum.

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!