Showing results for 
Search instead for 
Did you mean: 
New Member

Dataset with Parameter Row Limit Not Refreshing



I've set-up a parameter called RowLimit to limit the rows that are being fetched from a group of files. Basically, it allows me to control the number of rows i'm working with while on Power BI Desktop via an if statement:



if RowLimit > 0 then Table.FirstN(Source, RowLimit) else Source




Once I publish this to our workspace, I set the parameter to 0 and refresh the dataset so all the data is kept.


However, when I refresh the dataset, everything remains the same. I've also made the parameter visible on the data model so I can check if the value is being updated and it is. But the dataset is not getting updated. All of this works on Power BI desktop.

Other things that I have tried, but did not wor

  • Waiting for 30mins after I set the parameter before triggering a refresh
  • Using a scheduled refresh instead of a manual trigger
Super User
Super User

can you post all your power query code?

If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!

Helpful resources

T-Shirt Design Challenge 2023

Power BI T-Shirt Design Challenge 2023

Submit your creative T-shirt design ideas starting March 7 through March 21, 2023.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

March Events 2023A

March 2023 Events

Find out more about the online and in person events happening in March!

Top Solution Authors