For the past several hours, I've been trying to execute my SQL query through PowerPivot but I keep getting this error message: "Unable to convert a value to the data type requested for table (massive hex string) column (name)". Then I tried SSMS and it worked fine. What's causing the issue? Thanks.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!