Power BI and Power Query supports Basic Authentication, and the user will be prompted to enter the credentials as shown:

Credentials are cached by Power BI or Power Query hence the user may need to clear the permissions if the workbook is to be sent to other users
Clearing is done using Data Source Settings in Power BI/Power Query:

Please refer to Power BI/Power Query product documentations on managing credential and permission