Automate Power BI

[Arpita Nair]

I am having an excel sheet that keeps on changing every month. Do I have to prepare Power BI reports/dashboards every month. Does Power BI has the capability to just create the report when I replace the data every month.
1. I create a report/dashboard 1st time.
2. Every month I change the data and based on the report/Dashboard created for the very 1st time, every month the report is prepared automatically with just click of a button.

Thanks Arpita

 

[alansidman]

Simple answer is Yes. Once your code, (DAX or Mcode) is created all you will need to do is refresh the query so long as it has the same source location.