Home Forums Power Pivot Data format Issue !

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
  • #9732

    • Started: 1
    • Replies: 0
    • Total: 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 !?


    • Started: 7
    • Replies: 2566
    • Total: 2573

    Have you tried using Power Query (Get & Transform in Excel 2016)?

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.