(Solved) Power Query credentials with data from SharePoint

Hi Everyone,

I have an Excel file in A SharePoint folder meant as a template for users that can download it to run specific tasks.

To validate the template drop-down lists, the file gets data from another file in the same SharePoint folder which gets refreshed overnight through another integration.

Here's where it gets tricky: if User don't have Edit permission on the whole SharePoint site, they cannot validate their credentials when opening the template and the Query fails to run. 

Since I cannot grant Edit permissions on the whole SharePoint site, what can I do to solve the issue?

The query is based on the function Sharepoint.contents:

let
    Source = SharePoint.Contents("https://hanes.sharepoint.com/sites/mysite", [ApiVersion = 15]),
    #"Store timesheets" = Source{[Name="my SP folder"]}[Content],
    Template = #"my SP folder"{[Name="Template"]}[Content],
    #"my data source xlsx" = Template{[Name="my data source.xlsx"]}[Content],
    #"Imported Excel" = Excel.Workbook(#"my data source xlsx"),
    #"Excel Output_Sheet" = #"Imported Excel"{[Item="Excel Output",Kind="Sheet"]}[Data]

I need your help very bad!

Thank you!