I have a written a step by step guide on how to import data from SQL Azure to PowerPivot. In the article, i have also discussed couple of considerations while entering the SQL Azure credentials using the ‘SQL server native client 10.0’.
you can read the guide here:
Was taotlly stuck until I read this, now back up and running.