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
Community Championif you edit the Power Query you can add a filter to the files that you want - are their names static? if so then it should be quite straight forward
If not then you should create a filtering logic that would match the changing naming convention (e.g. get latest file for a given month, etc.)
They are static. How can I create this filter? Were excatly?
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
- Stachu
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