automated testing in Power BI

[vanessafvg]

do you know of any products where you can do automated testing in power bi?

[Brendon]

@vanessafvg I know this post is now about 3 years old but I'll post here in case anyone else finds the answer useful.

As of May 2021, there aren't any tools that I'm aware of that were specifically made for testing Power BI. 

If you want to test Power BI reports after being deployed to the service, you could do so using Selenium. This is possible (I've done it for a client) but has its own set of challenges (speed, scalability, distinct skillset). 

Some of the ETL and BI testing tools have started or are planning on adding support for Power BI. Tools such as DataGaps, Kinesis CI, etc.

I personally went down the Selenium route but ended up building PowerTester as a dedicated Power BI test automation solution to get around some of the challenges we faced when using a Selenium framework. 

[Whigpresident]

I would be interested in this as well.  Basically, do visuals render without errors on a report.  That's the most important to me.  The idea is that you can deploy a report to a prod report server and not have to click through all the tabs.  Shortens the release cycle, etc.  1/0 result for all visuals render successfully.

[v-jiascu-msft]

Hi @vanessafvg,

Which aspects do you want to test?

1. The Desktop or the Service?

2. The reports or the Dashboards?

3. What's the results you expect?

Best Regards,

Dale

[vanessafvg]

@v-jiascu-msft any and all of the above , i want to know whats available out there

[v-jiascu-msft]

Hi @vanessafvg,

As far as I know, there isn't such a tool. If you want to test your Power BI embedded, that actually has little connection with Power BI. For example, if you embed the Power BI reports in a JavaScript application, most of the testing could be testing the JS scripts. Some other references as follows:

https://www.youtube.com/watch?v=UFbCh5TaR4w

https://microsoft.github.io/PowerBI-JavaScript/demo/v2-demo/index.html

Best Regards,
Dale

[vanessafvg]

@v-jiascu-msft  thanks ill check it out