Forum Discussion
Custom partition incremental Refresh
Hello I have a fact table with a date column. I want to import data for last 2 years, then access the older data (more than two years) on direct query. About the refresh, I need to do two refreshs...
Anonymous , You can not have two settings for incremental. But if you are a premium customer, after enabling XLMA endpoint you can manage this from SQL server management studio
Power BI Premium - XMLA Endpoint - Data Refresh using SQL Server Management Studio (refresh table/tables as per need): https://youtu.be/kyCnnpjOwpI