How to selectively choose days based on folder structure within parameters?

[jaryszek]

I have folders structurized like that:
AmortizedCosts\
Daily\
2025\
04\
Fct_EA_AmortizedCosts_04.01.2025.csv
Fct_EA_AmortizedCosts_04.02.2025.csv
05\
...
Monthly\
2025\
Fct_EA_AmortizedCosts_04.2025.csv
Fct_EA_AmortizedCosts_05.2025.csv

and now it is easy to set up to load them using Folder.Files and StartRange and EndRange paramenters.

but how to select some days from different time ranges for example 01.04 and 07.04 (only 2 days)?
How to make these set up with parameters?

Best,
Jacek

[jaryszek · Accepted solution]

Ok solution will be:

- Introducing 4 parameters:

1) Granularity : monthly, daily, yearly
2) Year
3) Month
4) Day

If user will choose Daily granularity, he can put as Days parameter 1, 2, 3-5 so it means that for given year and month it will select partitions like 2025, 04, and days : 1,2, 3,4, 5. 

So based on this i can selectivly choose which data has to be imported. 

Best,
Jacek

[jaryszek]

Selectively import partitions, yes

[lbendlin]

Use your tool of choice (SSMS, PowerShell, Power Automate etc) to issue the appropriate XMLA script commands to the semantic model.

{
"refresh": {
"type": "full",
"objects": [
{
"database": "NA Cube",
"table": "Facts",
"partition": "2023Q1"
},
{
"database": "NA Cube",
"table": "Facts",
"partition": "2024Q3"
},
{
"database": "NA Cube",
"table": "Facts",
"partition": "2025Q1"
},
{
"database": "NA Cube",
"table": "Facts",
"partition": "2025Q2"
}
]
}
}

[v-dineshya]

Hi @jaryszek ,

Thank you for reaching out to the Microsoft Community Forum.

Hi @lbendlin , Thank you for your prompt response.

Hi @jaryszek ,  Could you please try the proposed solution shared by @lbendlin . Please do let us know if you have any further queries.

Regards,

Dinesh

[v-dineshya]

Hi @jaryszek ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

Regards,

Dinesh

[lbendlin]

What do you mean by "select"  ?  Are you looking to selectively refresh partitions?