Forum Discussion
Connecting Power BI to a folder
you need to do the following:
1) go to the Query Editor
2) select the query you want to edit from the query list on the left
3) have Query Settings enabled (first icon in the View ribbon)
4) select the first step in the Applied steps list (most likey it's named Source)
5) in the main window you should see the table with file names - you can filter there using the button in the right side of column name
They are static, but I need these especific files for each month:
27/01/2018
28/02/2018
30/03/2018
27/04/2018
29/05/2018
26/06/2018
28/07/2018
26/08/2018
27/09/2018
28/10/2018
29/11/2018
26/12/2018
Community Championyou need to do the following:
1) go to the Query Editor
2) select the query you want to edit from the query list on the left
3) have Query Settings enabled (first icon in the View ribbon)
4) select the first step in the Applied steps list (most likey it's named Source)
5) in the main window you should see the table with file names - you can filter there using the button in the right side of column name