I am pulling from an underlying dataset that I do not have access to and there is no date/timestamp for the entry of data into this dataset.

I have been working with a dataset of a toys production company. They have been producing toys since 1990. They have production in multiple locations all around the globe. I have a sheet which has the following data – serial no. of the toy, type of the toy, revision of the type of the toy, location where it was produced, feeder line used, machine used, date of start of production of the toy and completion of production of the toy. Each toy has it’s own serial number. There are around 20 different types of toys. Most of the toys has had revisions at some point of time. A feeder line comprises of 2 machines which share the same feeder input (One could use only one machine per feeder line or both). So, if I have two feeder lines say, FL001 and FL002, then my machines could be FL001-M1, FL001-M2, FL002-M1 and FL002-M2. Now, I have around 200,000 rows of data and I’m about to analyse them in PowerBi.

I have been working with a dataset of a toys production company. They have been producing toys since 1990. They have production in multiple locations all around the globe. I have a sheet which has the following data – serial no. of the toy, type of the toy, revision of the type of the toy, location where it was produced, feeder line used, machine used, date of start of production of the toy and completion of production of the toy. Each toy has it’s own serial number. There are around 20 different types of toys. Most of the toys has had revisions at some point of time. A feeder line comprises of 2 machines which share the same feeder input (One could use only one machine per feeder line or both). So, if I have two feeder lines say, FL001 and FL002, then my machines could be FL001-M1, FL001-M2, FL002-M1 and FL002-M2. Now, I have around 200,000 rows of data and I’m about to analyse them in PowerBi.

I have been working with a dataset of a toys production company. They have been producing toys since 1990. They have production in multiple locations all around the globe. I have a sheet which has the following data – serial no. of the toy, type of the toy, revision of the type of the toy, location where it was produced, feeder line used, machine used, date of start of production of the toy and completion of production of the toy. Each toy has it’s own serial number. There are around 20 different types of toys. Most of the toys has had revisions at some point of time. A feeder line comprises of 2 machines which share the same feeder input (One could use only one machine per feeder line or both). So, if I have two feeder lines say, FL001 and FL002, then my machines could be FL001-M1, FL001-M2, FL002-M1 and FL002-M2. Now, I have around 200,000 rows of data and I’m about to analyse them in PowerBi.

I have been working with a dataset of a toys production company. They have been producing toys since 1990. They have production in multiple locations all around the globe. I have a sheet which has the following data – serial no. of the toy, type of the toy, revision of the type of the toy, location where it was produced, feeder line used, machine used, date of start of production of the toy and completion of production of the toy. Each toy has it’s own serial number. There are around 20 different types of toys. Most of the toys has had revisions at some point of time. A feeder line comprises of 2 machines which share the same feeder input (One could use only one machine per feeder line or both). So, if I have two feeder lines say, FL001 and FL002, then my machines could be FL001-M1, FL001-M2, FL002-M1 and FL002-M2. Now, I have around 200,000 rows of data and I’m about to analyse them in PowerBi.

Hope all is well! Im using Power BI Desktop and Im trying to connect to data via an API POST request. Im going through Power Query M to gather the data but fairly new at it.

The following steps perform a Full Outer Join, then Append operation on two tables of about 1.5 million records each.