Forum Discussion

CherryKom's avatar
CherryKom
Frequent Visitor
3 years ago

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 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

data protection
Interesting Links
Need Help
Tips and Tricks
Tutorial Requests

2 Replies

    • CherryKom's avatar
      CherryKom
      Frequent Visitor
      3 years ago

      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.