Forum Discussion

ykannan's avatar
ykannan
Helper I
5 years ago

Dynamic M Query - Bind To Parameter not available

Hi, Dynamic M Query feature I am trying with Oracle DB source. I am not seeing the Bind To Parameter. In limitation, I have seen Oracle not supported. Please enable for Oracle. Or is there a workaro...
Need Help
v-deddai1-msft's avatar
v-deddai1-msft
Community Support
5 years ago

Hi ykannan ,

 

As mentioned in offical document: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters  Dynamic M query parameters don't support for Oracle.

 

You may need to create a date table in your data model. But it will  gett change to Mixed Storage mode. If you want to keep direct query mode, you'd better consider to create date table on database side. 

 

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

 

Best Regards,

Dedmon Dai

  • ykannan's avatar
    ykannan
    Helper I
    5 years ago

    Hi Dedmon Dai,

    I have Date table from DB. Please refer my second post. Also I exported my data from oracle to Excel and used Excel as my source. So the option should work for excel. But not. Could you able to share a pbix file with simple data in excel and enable the Bind to parameter?