Hello,
I am attempting to download data through an ODBC in excel 2013 (i.e. Customer Sales Data). The ODBC data is fine whenever I preview it; however, whenever I transfer the data into the PowerPivot the Sales Data Column only takes the first digit of the value (i.e. 40.56 $ transfers to 4 within Sales Data column in the Power Pivot). I know I can change the query string on the dimension to say Left(Sales Data, 10) to get the number I want, however, it is annoying to do this each time for all of the value fields. Does anyone know how to solve this issue???? Please???
Thanks in advance
I am attempting to download data through an ODBC in excel 2013 (i.e. Customer Sales Data). The ODBC data is fine whenever I preview it; however, whenever I transfer the data into the PowerPivot the Sales Data Column only takes the first digit of the value (i.e. 40.56 $ transfers to 4 within Sales Data column in the Power Pivot). I know I can change the query string on the dimension to say Left(Sales Data, 10) to get the number I want, however, it is annoying to do this each time for all of the value fields. Does anyone know how to solve this issue???? Please???
Thanks in advance
