View My Drafts
Can we filter out the data of related table (dimension tables) on the basis of one table (fact table) while converting from Direct Query mode to import?
For example – My fact table contains billions of records including date column. I want to import only current year data and the related dimension table should automatically filtered out on the basis of fact table. Is it feasible to achieve in Power BI?