Parameters not showing up in the Power BI Service for incremental refresh

[vdburg]

Hi,

I have been using Incremental Refresh for years. Now, suddenly when configuring a new report it doesn't show up in the Power BI service. It keeps saying that the parameters are still not defined in power query. 

I have configured the parameter RangeStart and RangeEnd, both as DateTime, on a datetime column. Then In the model view enabled Incremental refresh, keeping the last 10 years and updating the last 1 year. Published several times. It doesn´t appear.

Maybe I am missing something or something changed recently?

Best regards,

[vdburg]

Thank you both @MasonMA and @ibarrau for taking the time to look at your end. I guess they depreciated it and should work somehow with the defined parameters in desktop

[MasonMA]

Can you share M query just for the relevant table? 

[vdburg]

Hi @MasonMA,

let
Origen = Sql.Database("UNIPRBISQL01\UNIPRBISQL01", "dwh_unicef"),
dbo_FACT_COMPROMISO = Origen{[Schema="dbo",Item="FACT_COMPROMISO"]}[Data],
#"Otras columnas quitadas" = Table.SelectColumns(dbo_FACT_COMPROMISO,{"ID_COMPROMISO", "FEC_ALTA", "FEC_MODIF_REGISTRO"}),
#"Filas filtradas" = Table.SelectRows(#"Otras columnas quitadas", each [FEC_MODIF_REGISTRO] >= RangeStart and [FEC_MODIF_REGISTRO] < RangeEnd),
#"Filas ordenadas" = Table.Sort(#"Filas filtradas",{{"FEC_MODIF_REGISTRO", Order.Ascending}})
in
#"Filas ordenadas"

[MasonMA]

Your queries are actually structured correctly for Incremental Refresh. 

Thanks to @ibarrau . I validated from my end and it's true they no longer appear in Service. 

[vdburg]

Hi,

I am adding more examples: This is what I do have for older reports in the power BI service:

Now, I configure the same way I get this:

[ibarrau · Accepted solution]

Yes. I understood. I'm saying it's ok not seeing the incremental refresh parameters. I have checked in an old report and I don't have them at Service. If it let you run a refresh after publishing everything activated, it should be working. You can validate the partitions with dedicated or ppu capacity to make sure it's there.

Regards

[vdburg]

Hi @ibarrau,

We only have pro licenses, so It´s my understanding that I am unable to connect to a xmla endpoint.

I thought maybe you don´t have to define the parameters again in the service, and that by defining them in Power BI desktop it should work, but I tried to see what happens if I just define to update the last 3 days, but it takes too long. So I don´t think it´s working.

Best regards

[ibarrau]

Hi. I'm not sure what the problem is here. When you configure regular parameters you will see them in the semantic model settings. However, when creating RangeStart and RangeEnd as datetime configuring incremental refresh, I don't remember seeing those for a long time in PowerBi Service. That's how you know it has worked in pro, because they are not there. After configuring and sending to service, just refresh to make sure it works. 
If it's a dedicated capacity workspace you can validate it connecting from SQL Manangement studio to the xmla endpoint to check partitions.

I hope that helps,