search

Seddryck / NBi

NBi is a testing framework (add-on to NUnit) for Business Intelligence and Data Access. The main goal of this framework is to let users create tests with a declarative approach based on an Xml syntax. By the means of NBi, you don't need to develop C# or Java code to specify your tests! Either, you don't need Visual Studio or Eclipse to compile your test suite. Just create an Xml file and let the framework interpret it and play your tests. The framework is designed as an add-on of NUnit but with the possibility to port it easily to other testing frameworks.
http://www.nbi.io
Apache License 2.0
106 stars 37 forks source link

Supporting Power BI service datasets #712

Open xgilis opened 1 year ago

xgilis commented 1 year ago

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 commented 1 year ago

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

xgilis commented 1 year ago

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.