Power Query from SQL Server DB - set credentials

[zico8]

Hi,

I have created some files that get data from SQL Server Database by Power Query.
I need to share these files to my colleagues.

How can I set credentials so they will not be prompted about it? Maybe somewhere inside macro?

I have only refreshing event during opening file (ThisWorkbook.Connections("Query - MyQueryName").Refresh)