How to create the same visuals for a new dataset

[Anonymous]

I'm a new PowerBI desktop user, and I created some visuals for my organization using September data. I'd love to easily create the exact same visuals using the data from August (in a separate excel sheet). Does anyone know how I could quickly do this?

[Nathaniel_C]

Hi @Anonymous ,

One of the great things about Power Query is that it stores all the steps of your query, and by changing the source you will have the same steps apply to the new query/new source. So, open your Power Bi file, save it under a new name like August. Click on Edit Query, Click on the little gear icon as in my picture - change to your new source. Then when you go to the end of the steps (I am assuming the data is in the style as previous just different Excel file) your table will be ready to import to Power BI with all the new data.

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel