Forum Discussion
How automate dashboard template data change
I have created a dashboard template. When i use the template in other places I want to change the data source to a new folder hosted on sharepoint library. The files and the column name is the sam...
Anonymous , You can use an M parameter for connection, that helps in changing it fast
refer from Guyincube - https://www.youtube.com/watch?v=OnaDJkGOmIE
Or refer
https://radacad.com/change-the-source-of-power-bi-datasets-dynamically-using-power-query-parameters
This also helped https://www.youtube.com/watch?v=gJF2e_43FRY
Automating the process of changing data sources in your dashboard template can save you a lot of time and effort, especially when dealing with multiple data files for different companies.