Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.