Supporting Power BI service datasets

[xgilis]

Hello,

New feature request: Is it an option to support this Power BI feature as a connection for NBI? https://endjin.com/blog/2022/01/testing-power-bi-reports-using-execute-queries-rest-api/

A recent API was added that allows you to execute DAX queries to Power BI service datasets.

Kind regards, Xavier

[Seddryck]

Yes it should be possible. I'll take a look to that.

[xgilis]

Interesting to note that the "Datasets - Execute Queries" API is available for both Power BI Pro and Power BI Premium. Cause on the Power BI Premium side we had options for querying datasets on the service already a longer time via the XMLA endpoints. This blog post also talks about some differences: https://powerbi.microsoft.com/en-za/blog/executequeries-rest-api-versus-xmla-endpoints-at-scale/

Pro's of the "Datasets - Execute Queries" API is that it's more universal type of connection and available to anyone (Pro and Premium). Downside is there are limits to the amount of data we can communicate.