Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
SG_synapx
Frequent Visitor

Incremental Refresh - Power BI not detecting parameters

Hi,

 

We're looking to set up incremental refreshes for one of our queries, coming from an ODBC source. Following the suggestions in this link here, we defined two parameters 'RangeStart' and 'RangeEnd', that were configured as dates. The next step is then filtering the table using those parameters in Power Query, which was no problem, so we clicked 'Close & Apply'. When we then try to configure the incremental refresh in the data view we're presented with the following error message.

 

 

Screenshot 2023-06-05 171503.png

 

If anyone has encountered this or knows of ways around it it would be greatly appreciated, this has frustrated us to no end!

 

Thank you,

 

Shane

3 REPLIES 3
NaveenGandhi
Super User
Super User

Hello @SG_synapx 

Once the parameters are set up, a Custom filter must be created in ur table that uses the above-created parameters. Did you do that?

NaveenGandhi_0-1685984418473.png

 

Let me know if this helps!

If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!

Hi Naveen,

 

Thanks for the quick response. Yes, this step was completed with no problem. The issue we're having is that once we've loaded the data from Power Query the next step in setting up the incremental refresh, and this will not work.

 

Thanks,

 

Shane

@SG_synapx 

I can suggest you couple of ways to debug this.

  • Please ensure you already enabled the "Incremental Refresh Policies" preview feature in desktop. 
  • See if you set RangeStart and RangeEnd as datetime, it should be defined as datetime
  • Can you check the last step of your query to see if native query is greyed out as below.

 

file.png

  • If this is greyed out, navigate to prior steps one by one and see which step still has native query not greyed out. Remove all the steps below that and try now.

 

Note: don't remove the filter parameter step, just rearrange it.

 

Let me know if this works!

 

Regards,

Naveen

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.