Unit testing PowerBI.com (Power BI Service)

[Safariba]

Can we write unit tests testing individual DAX queries of the PowerBI .com dataset. Can we influence the data in the dataset (to set the preconditions of the test)?

[Seddryck]

No, there is no solution for this (AFAIK).

[johnwww]

Has someone managed to connect to a PBI online dataset? If I take the connectionstring used to connect Excel it uses a ClaimsToken authorization that is not working in NBi

[Seddryck]

It's not supported by NBi and AFAIK, it's not possible.

[mbodtke]

Update on this: XMLA endpoints allow you to use a variety of third party tools against datasets that are in a powerbi workspace associated to a premium capacity. See here for more information and how to enable: https://docs.microsoft.com/en-us/power-bi/admin/service-premium-connect-tools

A few of us have been able to get NBI v1.22.0 working with XMLA endpoints by:

1. Installing latest MSOLAP (15.1.48.22 at time of writing) from here: https://docs.microsoft.com/en-us/analysis-services/client-libraries?view=asallproducts-allversions
2. Using the following connection string in the .nbits file Provider=MSOLAP.8;Data Source=powerbi://api.powerbi.com/v1.0/myorg/<workspace_name>;Initial Catalog=<dataset_name>;User ID=<[email protected]>;Password=<password>

[Johannes-Vink]

In addition to this: XMLA endpoints are Premium only. However there is also a public preview of a read-only DAX REST API where in the REST call DAX is encapsulated: https://powerbi.microsoft.com/en-us/blog/announcing-the-public-preview-of-power-bi-rest-api-support-for-dax-queries/

And the documentation: https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/execute-queries