You need to login in within the Azure SQL Database via an AD account that has DB_owner role.
Then execute the below commands :
Create user [<<SPName>>] from External provider
Grant [<<SPname>>] Select on <<TableNm>> --in case if access on specific table
If read access on entire DB :
EXEC sp_addrolemember 'db_datareader', '<<spname>>';