Forum Discussion
Solved
Newbie question
Hi - I was hoping for some help - I put together my very first desktop power bi with sales, distributor and product data pertaining to commissions from our sales reps around the United States. I am...
Ok - so you can see the file it's referring to. Also you can see that it's taking only the first 18 columns from that file.
And one final thing you can see is that there is one filter set up and it filters the data to only rows where [Month] = 12.
Now I don't know what the logic behind that is, but that is what's set up. It might be just the final year's data... don't know.
OK you are right. I am adding it to an existing spreadsheet that is already being utilized in power bi. I use the transform data button, data source settings, and then making sure it is on correct sheet.