Forum Discussion
Remove duplicate rows when refreshing
Hi, Anonymous
Based on your description, I'd like to suggest you refer to Referencing Power Query queries about reference. You may parameterise a data source to load the entire folder. For further information, please refer to the following links.
https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/
https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hello, i create a reference from my sample file but when I refresh, only load the file that used for the sample, what should I do to use the parameters that a I set and load the entire folder?
Hi, Anonymous
Based on your description, I'd like to suggest you refer to Referencing Power Query queries about reference. You may parameterise a data source to load the entire folder. For further information, please refer to the following links.
https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/
https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.