![]() ![]() To overcome this (and because it might be good practice anyway):Ĭreate a numerical index column that you use as your new key. SAP PowerDesigner software can also draw diagrams and modeling the ERD. ![]() This further means that you will not be able to connect you new Dimension table to your Fact table as the Dimension table now has dups. Once you load this into your Power Pivot data model, it will be shown there as “Car” and “Car” or “car” and “car”, depending on which term was the first in the list (will always take the first one). Power Query is case sensitive and will consider “Car” and “car” as different, returning both after the remove duplicates step. However – you might experience a problem if the key to your Dimension table that you’re extracting from the Fact table is text and not number format. Creating a Dimension table from a fact table using Power Query is really straightforward using the Remove Duplicates function. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |