Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors