Showing results for 
Search instead for 
Did you mean: 
Post Prodigy
Post Prodigy

parameterised datasets based on user input - best way to achieve



If have a large dataset and want to limit the dataset to those rows interested in based on user input rather than bring everything in and then filter afterwards which would in any case exceed the 1gb file size limit in power bi pro.


e.g rather than import all calendar years - import just calendar data for year = year input by user 

then import the sales data for that calendar year.


How can this best be achieved in power bi?



Super User I
Super User I

See if this YouTube video on Direct Query helps...  I also pulled some notes from the Microsoft Docs below...

Benefits of using DirectQuery

There are a few benefits to using DirectQuery:

  • DirectQuery lets you build visualizations over very large datasets, where it would otherwise be unfeasible to first import all of the data with pre-aggregation
  • Underlying data changes can require a refresh of data, and for some reports, the need to display current data can require large data transfers, making re-importing data unfeasible. By contrast, DirectQuery reports always use current data
  • The 1-GB dataset limitation does not apply to DirectQuery

Did I answer your question, or help you along the way?
Please give Kudos or Mark as a Solution!

Proud to be a Super User helping give back to the community!
Thank You!

Post Prodigy
Post Prodigy

Thanks for suggestion - in our case the underlying queries would take way more than 30 secs thus direct query not practical for us in this case - we wish for the data to be imported in quiet hours.


Any other thoughts parameterised datasets based on user input with import mode?

Helpful resources

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!


Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors