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>
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:
Make sure you are in the “Data” Tab in the connector
Right-click on the respective table, here the table name is <table_name>
Go to Advanced
Click on options
Under the Advanced section you will find a attribute called “Table Scope”
Choose the respective place (Workspace or Serverdata) of data available and Click Ok
Reload the table
Click on “Yes” if prompts to added new attributes
Data is loaded now!
A detailed official document on table scope: [Table Scope](https://UiPath Process Mining: Table Scope)