Step 1: View Semantic Model and configure your excel according to the tables supported.
Note: Keep column names consistent with the tables in the semantic model. Remember to name the sheets in the excel as the correponding table names in the model.
Step 2: Click On Conect your data.
Step 3: Open your onedrive and navigate to the new data file. Find the path to the file in Details.
Step 4: Paste the path link in the SharepointURL parameter.