cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
HarjyotKaur
New Member

Automation Testing using Selenium

Hi,

 

I am trying to automate my Power BI report validation. Basically, we want to make sure that the output generated on the report matches the datasource manipulation. For that, I am using Selenium to extract the values of the objects using their Xpath or Css selector. The challenge is everytime I run my script, the path changes. Does anyone know why does that keep happening. I checked with the developers and they assured that nothing from the UI got changed.

Is there any other tool for automation testing?

Any help is much appreciated!

 

Thanks,

Harjyot

3 REPLIES 3
Brendon
Frequent Visitor

@HarjyotKaur what kind of selectors are you using? I've had some luck in using CSS selectors and requesting developers to put alt-text on all charts I need to interact with. In the DOM, you'll see the alt-text as "aria-label" attributes, so you can write CSS selectors like, "div.slicer[aria-label*=\"YOUR_ALT_TEXT\"]". These tend not to change much as long as you find the right element to use. 

 

As for your question about other tools, I developed PowerTester after going down the selenium route for a client and finding that the amount of work involved in creating and maintaining tests became the bottleneck for our team. 

Syndicate_Admin
Administrator
Administrator

Hi! I'm going to write Portuguese, and I hope you can understand. Are you using Selenium through Power BI service or desktop?
I'm trying to do something like that in an online report, but the script can't interact with the elements.
My goal is to automatically export the data from a table in the visual.
Can you use filters and select elements with Selenium? Any tips that can help me?

thanks!

Greg_Deckler
Super User IV
Super User IV

@HarjyotKaur No specific tools that I know of but there is a blog article for DAX testing:

https://powerpivotpro.com/2018/09/automated-testing-using-dax-for-power-bi/

 

No idea about Selenium. Would need to know more about the script and how it is accessing the report.


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Urdu Hindi D365 Bootcamp 768x460.png

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.

Top Solution Authors
Top Kudoed Authors