Forum Discussion
Load huge data from oracle using parameters and allowing the end user to change parameters in PBI
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...
v-jianboli-msft
Community Support
Community SupportHi 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.