Forum Discussion
Parameters incremental refresh not found
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')