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 same its' just that they are in different folder for different comapanies. Even the data transformation steps are same for each files.
One way is to manually go chnage the source in advanced editor but, i want to automate the process since there are many data files
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
3 Replies
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.
