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
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

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.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Kudoed Authors