Skip to main content
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

Frequent Visitor

Load huge data from oracle using parameters and allowing the end user to change parameters in PBI



We have a scenario in which we are using Oracle as the data source and pulling huge volumes of data using import mode(as the data columns got calculations we can't use direct query).


Here we want to filter out the data using parameters before loading it, and we were able to do using parameters. However, our client wants us to provide their end users with an option of changing the parameter values in the Powerbi service. We found an option using PowerApp, but at this point in time we can't use it because of licensing costs. 

Can someone please suggest any workaround for achieving this requirement? 



Thanks in advance.


Community Support
Community Support

Hi @CherryKom ,


With dynamic M query parameters, model authors can configure the filter or slicer values that report viewers can use for an M query parameter.


For more details, please refer to:

Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn


Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi v-jianboli-msft,


Thanks for the response, the query that we are using to get the data has got calculated columns so we can't use Direct Query. Is there any other way to do this? Please suggest.


Thanks in advance.

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.