Unable to get to the last row in CV extraction

Help Studio
, ,
1

Hello, i am currently using CV table extraction. However, the activity is unable to get to the last table row and will stop itself in the middle of the table (all elements are still visible on screen) I want to be able to get to the last row using this particular activity. Any suggestions would be helpful, thank you!

2

Hi @Sadder

There could be multiple reasons like

  1. Check with the web page whether it has loaded completely before extraction
    Sometimes it may load faster sometime may not
    Use a relevant activity like IMAGE EXISTS or ON IMAGE APPEAR or ON ELEMENT APPEAE activity and then go for extraction
  2. Or it can be because of package version that is your project will have few basic default project dependencies
    It has to be updated to latest version and for that Go to Design tab → Manage Packages → Project Dependencies-> upgrade the packages

Regards,

3

@Sadder

Hi,

  1. In CV Scope try to indicate the whole page So that it can extract all the webpage details.

  2. Adjust the OCR Engine: The CV activities utilize OCR (Optical Character Recognition) to extract text from the screen. Different OCR engines may have varying levels of accuracy and performance. Try switching the OCR engine used by the CV activities. You can experiment with different options such as Google Cloud OCR, Microsoft OCR, or Abbyy OCR to see if it improves the table extraction results.

  3. Increase Timeout or Delay: Sometimes, the CV activities might require more time to accurately detect and extract table rows, especially if there are complex layouts or if the last row takes longer to load. You can increase the timeout or add a delay before or after the table extraction activity to give it more time to complete the operation.

Thanks

4

Hi, @Sadder. All good?!

I usually scroll the screen to extract the table once again. Then, I perform a merge with the previous table and remove duplicate rows. This problem seems to occur when the table data gets updated dynamically, requiring me to re-extract and update the information accordingly.

I hope this helps, hugs!

5

@Sadder

As suggested earlier…please try with first scrolling the table and then extract as they are dynamic powe bi tables

Or try using the export functionality that is provided in build in power bi which makes your life easy

Hope this helps

Cheers