Forum Discussion
jaryszek
Super User
Super UserHow to selectively choose days based on folder structure within parameters?
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_AmortizedCos...
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
jaryszekSuper User
Super UserSelectively import partitions, yes
lbendlinSuper User
Super UserUse 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-dineshyaCommunity Support
- 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