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

[CherryKom]

Hi,

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.

charishma

[v-jianboli-msft]

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.

[CherryKom]

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.