Power Bi Increment Refresh ( SSAS MD Cube Import )

Hi,

Due to large data set in cube,I m only importing filtered data from cube using MDX query.

  SELECT NON EMPTY { [Measures].[DailySMSSent], [Measures].[DailySuccessfulCalls], [Measures].[DailySuccessfulReceivers], [Measures].[DailyUserMinutes], [Measures].[DailyVIMSent], [Measures].[RL28DaysActiveUsers], [Measures].[RL28DaysAppForegroundUsers], [Measures].[RL28DaysCallingActiveUsers], [Measures].[RL28DaysCircuitActiveUsers], [Measures].[RL28DaysCommsActiveUsers], [Measures].[RL28DaysEngagedCredits], [Measures].[RL28DaysIMReaders], 
  [Measures].[RL28DaysIMSenders], [Measures].[RL28DaysIMSent], [Measures].[RL28DaysNewActiveUsers], [Measures].[RL28DaysNewCircuitActiveUsers], [Measures].[RL28DaysNewEngagedUsers], [Measures].[RL28DaysNewRegisteredUsers], [Measures].[DailySuccessfulCallers], [Measures].[RL28DaysReachableUsers], [Measures].[RL28DaysSMSSent], [Measures].[DailyNewEngagedUsers], [Measures].[DailyActiveUsers], [Measures].[DailyAppForegroundUsers], [Measures].[DailyCallingActiveUsers], [Measures].[DailyCircuitActiveUsers], [Measures].[DailyReachableUsers], [Measures].[DailyEngagedCircuits], [Measures].[DailyCommsActiveUsers], [Measures].[DailyEngagedCredits], [Measures].[DailyIMReaders], [Measures].[DailyIMSenders], [Measures].[DailyIMSent], [Measures].[DailyNewActiveUsers], [Measures].[DailyNewCircuitActiveUsers], [Measures].[DailyNewRegisteredUsers] } ON COLUMNS, NON EMPTY { ([Activity].[Activity].[Activity].ALLMEMBERS * [Activity].[ActivityGroup].[ActivityGroup].ALLMEMBERS * [Platform].[BIPlatform].[BIPlatform].ALLMEMBERS * [Platform].[BIPlatformGroup].[BIPlatformGroup].ALLMEMBERS * [Date].[Date].[Date].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS
   FROM ( SELECT ( [Date].[Date].&[2018-08-15T00:00:00] : [Date].[Date].&[2018-10-15T00:00:00] ) ON COLUMNS FROM [KPICube]) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS

Now i have to implement Incremental Refresh but Native query is disabled.

h

a) How would I implement incremental refersh when Native query is diabled ?

b) Please suggest any alternate methd because I cant import complete data from Cub.

Hi atul9063,

AFAIK, current increment refresh feature is based on query editor filters and parameters, I don't think it is possible to enabled in live connection.

Regards,

Xiaoxin Sheng