Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Pandadev
Post Prodigy
Post Prodigy

Python code keeps breaking scarping my own reports to get metrics

I create a dax formula table in my powerbi report and I have ran code in python to select my workspace , select the report and then click on the table and click on export to excel.

My issue is that something strange is happening on this line code when I am selecting the report 

I am using python selenium

driver.find_element_by_link_text("Metrics NewZealand").click()

when I re run the code with Katalon recorder , it appears to have exactly the same code , when I put it next to the original code

but when I replace it , it works.

Is there some form of font change happening.

 

 

1 REPLY 1
v-jingzhang
Community Support
Community Support

@Pandadev 

Sorry I am a little confused. Do you mean the code works when you run it with Katalon recorder but fails when you run it directly on your computer? Is there any error message in Python command window? Does it find the element successfully?

 

Additionally, what is the link refer to? I am not clear about what you are trying to export. Can you clarify the steps "click on the table and click on export to excel"? Maybe you can share a screenshot about this step. It is more intuitive to help us know what you want. Remove sensitive info before sharing. Thanks.

 

Regards,
Community Support Team _ Jing Zhang

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors