Forum Discussion
power quey advanced editer
I extracted data from the SharePoint and imported into power bi desktop but name of the files are same but but number before files are changing weekly ,I want set a body for that prefixes names for data refresh purpose .so how we set body of a power query advanced editor for power bi for SharePoint folder files.
can you people help me out of this ,what code should I use to fix the changing of prefixes names .can you tell me the code.
3 Replies
Hi Anonymous ,
One way is to get the data source using dynamic parameters.
Create a parameter for your file name and filter with the parameter. Please refer to
Solved: Dynamic Data Source based on parameter - Microsoft Fabric Community
Here's an example, create a parameter and replace the original file name with the parameter created. Next time you only need to modify the parameters, without modifying the code.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I extracted data from the SharePoint and imported into power bi desktop but name of the files are same but but number before files are changing weekly ,I want set a body for that prefixes names for data refresh purpose but I want get refresh latest file that added to the folder recently,I want to see latest data in my report. How Can I do It .can you please tell me
can you people help me out of this ,what code should I use to fix the changing of prefixes names .can you tell me the code.
I extracted data from the SharePoint and imported into power bi desktop but name of the files are same but but number before files are changing weekly , I want get refresh latest file that added to the folder recently,I want to see latest data in my report. How Can I do It .can you please tell me.
can you people help me out of this .