I'm using Power Query to extract data from a SSAS database. Each time PQ adds a column it names it as "Dimension.<Label>" ... for example, Dimension.Customer, Dimension.Product. I don't want the "Dimension." part - just the "Customer" or "Product" part.
I can't find a way to disable this behavior so I'm wondering what the best way to removing all characters up to the period "." for each column is? Preferably not manually.
Thanks
I can't find a way to disable this behavior so I'm wondering what the best way to removing all characters up to the period "." for each column is? Preferably not manually.
Thanks