Forum Discussion

Alchemista's avatar
Alchemista
Frequent Visitor
7 years ago
Solved

How to import Excel data keeping the same column formatting? (%, $ and Unit Values showing properly)

Hello,   New to Power BI, I have a question regarding how to successfully import data into Power BI with the same formatting as I see on Excel.   In my data pull I have several facts like region,...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • parry2k's avatar
    parry2k
    7 years ago

    Alchemista your modelling tab will be disabled if data type in power query is text or any (abc/123). as soon as you changed the data type to number/whole number , you have format options.

parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

Alchemista looks like it it is taking those column as type any may be there are some blank/empty cells in your data and that's why it is making it as type any. You can always change is in Power Query though.