How to retrieve data from SQL Server 2005 on Windows Server 2008 R2 on static IP, in a secured manner to Power BI?

That is what the Power BI Gateway is for. You install it on a machine in the same network as your SQL Server, and it makes an outbound connection to Power BI, listens for data requests and manages the connections to your private data sources.