Yes...if you're using 2-factor authentication in Azure, you need to set up an app password as Power Pivot may not support 2-factor authentication natively. See the following: https://docs.microsoft.com/en-us/azure/multi-factor-authentication/end-user/multi-factor-authentication-end-user-app-passwords