Forum Discussion
Parameters incremental refresh not found
Yep. Did that. Enabled load. Used them to customize the filter in the appropriate colomn (date type set to date/time) and configured the fct_table
Did you check the native query of the Filtered row in Power Query? if it is greyed out the it won't work in the service and you need to check the steps before which one is causing it
Hi, thanks for your reply. The native querie is fine. That is not the issue.
Can you right click on the step and show me the code please?
select [_].[Asset_BW_ID] as [Asset_BW_ID],
[_].[Contract_FM_ID] as [Contract_FM_ID],
[_].[Asset_Serie] as [Asset_Serie],
[_].[Asset_Serie_Number] as [Asset_Serie_Number],
[_].[t0_0] as [Alarm_Date_Made],
[_].[Alarm_Time_Made] as [Alarm_Time_Made],
[_].[Alarm_Time_Made_Seconds] as [Alarm_Time_Made_Seconds],
[_].[Alarm_ReactionTime_Seconds] as [Alarm_ReactionTime_Seconds],
[_].[Alarm_ProcessingTime_Seconds] as [Alarm_ProcessingTime_Seconds],
[_].[Alarm_CompletionTime_Seconds] as [Alarm_CompletionTime_Seconds],
[_].[Alarm_Type] as [Alarm_Type],
[_].[Alarm_Prompt] as [Alarm_Prompt],
[_].[Alarm_Processor] as [Alarm_Processor],
[_].[Alarm_Country] as [Alarm_Country],
[_].[Country] as [Country],
[_].[Date_Staging] as [Date_Staging],
[_].[Date_DWH] as [Date_DWH],
[_].[Source_System] as [Source_System]
from
(
select [_].[Alarm_Key] as [Alarm_Key],
[_].[Date_Key] as [Date_Key],
[_].[Alarm_BKey] as [Alarm_BKey],
[_].[Asset_Key] as [Asset_Key],
[_].[Contract_Key] as [Contract_Key],
[_].[Date_BW_ID] as [Date_BW_ID],
[_].[Alarm_BW_Key] as [Alarm_BW_Key],
[_].[Asset_BW_ID] as [Asset_BW_ID],
[_].[Contract_FM_ID] as [Contract_FM_ID],
[_].[Asset_Serie] as [Asset_Serie],
[_].[Asset_Serie_Number] as [Asset_Serie_Number],
[_].[Alarm_Time_Made] as [Alarm_Time_Made],
[_].[Alarm_Time_Made_Seconds] as [Alarm_Time_Made_Seconds],
[_].[Alarm_DateTime] as [Alarm_DateTime],
[_].[Alarm_ReactionTime] as [Alarm_ReactionTime],
[_].[Alarm_ReactionTime_Seconds] as [Alarm_ReactionTime_Seconds],
[_].[Alarm_ProcessingTime] as [Alarm_ProcessingTime],
[_].[Alarm_ProcessingTime_Seconds] as [Alarm_ProcessingTime_Seconds],
[_].[Alarm_CompletionTime] as [Alarm_CompletionTime],
[_].[Alarm_CompletionTime_Seconds] as [Alarm_CompletionTime_Seconds],
[_].[Alarm_Type] as [Alarm_Type],
[_].[Alarm_Prompt] as [Alarm_Prompt],
[_].[Alarm_Processor] as [Alarm_Processor],
[_].[Alarm_Country] as [Alarm_Country],
[_].[Country] as [Country],
[_].[Date_Staging] as [Date_Staging],
[_].[Date_DWH] as [Date_DWH],
[_].[Source_System] as [Source_System],
convert(datetime2, [_].[Alarm_Date_Made]) as [t0_0]
from [dbo].[Fct_Alarm] as [_]
) as [_]
where [_].[t0_0] >= convert(datetime2, '2022-01-01 00:00:00') and [_].[t0_0] < convert(datetime2, '2030-12-31 00:00:00')