Home › Forums › Power Pivot › Data format Issue ! Tagged: Data Model, PowerPivot, SAS, SharePoint, Text Fields This topic contains 1 reply, has 2 voices, and was last updated by tomallan 1 year, 3 months ago. Viewing 2 posts - 1 through 2 (of 2 total) Author Posts May 8, 2018 at 6:40 pm #9732 alanquadrosParticipant Started: 1Replies: 0Total: 1 Hey guys, I’m in trouble with data access (powerpivot + SSAS). Here is my cenario. I have a sp2016 server + powerpivot + Analisys Server. Where i created a powerpivot gallery… make one worksheet (datamodel.xlsm) which connects to SQL Server and SELECT some data from a view. So far… all ok. I’m trying to connect to my “model” in http://myserver/data/mymodel.xlsm using Excel Connection From Other Sources (Analysis Service). Connection Successful, but all my data comes as text !!! and i can’t use it to make graphs, tables, sums averages, etc…. I have checked all data types… on the datamodel worksheet… and numbers are numbers, dates are dates but when i connect… all becomes text (magic ?!) someone can help me !? May 8, 2018 at 9:26 pm #9733 tomallanKeymaster Started: 7Replies: 2566Total: 2573 Have you tried using Power Query (Get & Transform in Excel 2016)? Author Posts Viewing 2 posts - 1 through 2 (of 2 total) You must be logged in to reply to this topic.