Forum Discussion
Dataflow issue
It is good if you follow e.g. star schema in your model. For example all dimension tables like Date should be in single relationship to your fact table/s (one-to-many)
I'm assuming most of those 100s of columns describe the transaction.
You want to use power query to split them into logical groupings in separate dimension tables.
If all the data relates to a transaction I'd be tempted to use power query to merge the data on transaction id and end up with a single fact table with your dimensions coming off it.
However I still think something is missing from the description of the data. In your latest model you've got a many to many relationship between the two tables which would suggest that the same transaction appears multiple times in both tables or you're joining on the wrong field.
exactly. each row represents a single transaction.
Ive been using power query to append all of the files together into one large file (i have multiple clients and for each client i have a file for every months history= about 200 files) the fields that I am referencing are unique value fields to connect them. I will double check the data to verify this but there shouldnt be any duplicates when using these fields.