Parameters incremental refresh not found

[Erik1980]

Hi,

I configured incremental refresh on my datamodel. I believe I did everything okay in PowerBI Desktop and was able to publish the model to PowerBI Service ans set refresh rate in settings. Howver, it doesn't work, and when I select 'Parameters' it don't show RangeStart and RangeEnd, but tells me 'Parameters haven't been defined for this semantic model yet. If you want to set parameters, use the Query Editor. Learn more'. I enabled load/refresh of the parameters in PowerBI desktop and really don't know what else I can do.

[aj1973]

Hi @Erik1980 

First step is to create parameters " RangeStart and RangeEnd" in Power Query, did you?

[Erik1980]

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

[sergej_og]

Hey Erik,
your paramenters are also defined as Date/Time?

[Erik1980]

Yes, I did

[aj1973]

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

[Erik1980]

Hi, thanks for your reply. The native querie is fine. That is not the issue. 

[aj1973]

Can you right click on the step and show me the code please?

[Erik1980]

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')

[aj1973]

Is your Fact table in a Direct Query mode?

[Erik1980]

No. It's input mode