Trouble Deploying PowerPivot to SSAS, Connections

  • Hello, I have a PowerPivot model where am using a Query pulling from Teradata, and the connection works fine using a main username/password. I then Create a new project in Visual Studio, and bring in PowerPivot model through importing it, no issues. I also run a build, no issues. The problem comes up with trying to deploy, it asks for Data Source Credentials, and I give it the same main username/password to pull the query in the original PowerPivot, and that same username/password is the same one I use all throughout several SSIS jobs to connect to Teradata. I give the cred info, and it fails. I've tried all various combinations, Impersonation, and nothing seems to get by the Data Source Credential upon deploy. What else can I try? Thanks

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply