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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

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
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors