After I format my data in PQ and load it into a regular table, the formatting is lost.
I saw from some online research that there was a bug years ago?
Am I doing something wrong?
Hi Digalo,
What formatting did you do in Power Query? Power Query is really for setting data types, Excel is where you apply cell formats.
Mynda
Sorry, that's what I meant -- changing data types. Those formats (i.e Number, currency) don't stay applied when I load data from PQ to table.
That's correct. The data types are really for loading the data into Power Pivot where data types are used in the modelling. When you load the data into Excel you are free to apply cell formatting just as we normally would. The data types aren't really relevant to Excel, other than the Date type, which will automatically pick up a date format.
So, if you're only loading the data into Excel, don't worry about setting data types like currency, as this is irrelevant in Excel. Just make sure text is text, dates are dates and numbers are either whole or decimal.
