Forum Discussion
Template using excel files
Hi Anonymous
Or follow the document below
https://www.seerinteractive.com/blog/how-to-create-a-power-bi-template/
As tested, it works.
Please uncheck the "required" option and use parameter in your connection query.
Then close&&apply, go to report view, creat visuals.
when save, select "save as "->***.pbit
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
lbendlin Our files are currently stored in a shared folder. The parameter is set to ask the user for the file location. Once the new file location is added to access the new files the template loads in the original files instead of the new ones.
Hi Anonymous,
How are you using this parameter ? Can you show the m code for this query ?
The parameter is set up as a text and the Current value is the csv file. When opening the template it then promps you to enter a new file location.
The source of my file is an excel workbook with the file contents of the file location.
Anonymous ,
It looks like correct, can you share your m code ?
Also the data structure is the same for all the inputed files ?