Error: While loading <table_name> -> Failed to open Excel File

Hi together,

I am facing an issue using an excel file in the connection string in UiPath Process Mining.
The connection string looks like this " ‘driver={mvfile}; filename=Daten/OktoberKW41.XLSX;’ " and the file name is “OktoberKW41.XLSX” which is stored in folder “Daten”.

I’m getting the following errors (<table_name> is a placeholder for the actual table name):
Error: While loading <table_name> => Failed to open Excel file.
Error: Correct the datasource settings for this application to work. (<table_name>).
Error: no cached data found for: <table_name>

Has anyone an idea why this is happening?

Thank you in advance!
Robin

Hello @Robin_H,

Hope you are doing well!

You can notice the second error: “Error: Correct the datasource settings for this application to work.”. This indicates you to change the table scope in the options.

Inorder to change the table scope please follow the steps below:

  1. Make sure you are in the “Data” Tab in the connector
  2. Right-click on the respective table, here the table name is <table_name>
  3. Go to Advanced
  4. Click on options
  5. Under the Advanced section you will find a attribute called “Table Scope”
  6. Choose the respective place (Workspace or Serverdata) of data available and Click Ok
  7. Reload the table
  8. Click on “Yes” if prompts to added new attributes
  9. Data is loaded now!

A detailed official document on table scope: [Table Scope](https://UiPath Process Mining: Table Scope)

Please let me know if that works :slight_smile:

Regards,
Hari Vignesh.

Hi @hari.vignesh , Thank you for your help!
I could solve it myself after some hours of testing and suffering.
Your solution describes it very well!

1 Like

Hi @Robin_H,

Glad that the issue was resolved.
Thank you for the kind response!

Happy mining!

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.