In Power BI, select Manage Gateways:


Select Add data sources to use the gateway:

Give the name as Excel Spreadsheet and the type as File:

Provide the path to the file and also the windows username and password:

You can add multiple data sources by selecting Add Data Source:


Keep learning. Keep building.
Explore AI, agents & Microsoft technology.
I share practical ideas, tutorials, and videos about AI, AI agents, Microsoft technologies, and the Power Platform.
Subscribe on YouTube →Carl de Souza Enterprise Architect at Microsoft · AI Technology Expert