Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have the following file behavior:
(Today) 28-Apr-2017: STATIC_PATH\20170428-STATIC_FILENAME (Tomorrow) 29-Apr-2017: STATIC_PATH\20170429-STATIC_FILENAME ... (Monday) 01-May-2017: STATIC_PATH\20170501-STATIC_FILENAME (Tuesday) 02-May-2017: STATIC_PATH\20170502-STATIC_FILENAME And so on...
The filename changes on a daily basis, more especifically the date part. Is there a way to use it as a source in PBI automatically, so I don't need to go into source settings everyday and update the source path by hand?
Solved! Go to Solution.
Hi @JChris,
Check this video tutorial it as what you are looking for.
Regards
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsPlease watch this video
Here the file name keeps changing within a folder still fetchs the files
https://youtu.be/4UfkhF6uGcw
If you only want to get the file with todays date, you can use:
"STATIC_PATH\"&Date.ToText(DateTime.Date(DateTime.LocalNow()),"yyyyMMdd")&"-STATIC_FILENAME"
how to get yesterdays date.... ??
I want to get the file that is in the STATIC_PATH, no matter the date, the file is replaced, so yesterday file get out and todays get in the folder. Something like a regex: .*-STATIC_FILENAME would do if regex was allowed.
You can create a function to pass the file path and file name. Then you can iterator all files under that folder and combine them into one dataset. For more details, please refer to this blog: USE POWER QUERY’S GET DATA FROM FOLDER TO GET DATA FROM MULTIPLE EXCEL FILES
Regards,
Then you can use "Get files from folder" as suggested by @MFelix
Hi @JChris,
Check this video tutorial it as what you are looking for.
Regards
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
73 | |
65 |