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

Need Help

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    I too am having no luck with this preview option. I am trying to have the City be a parameter. I have tried using an existing table (that fills my slicer) which comes from Excel data.  I have tried a hard-coded list of cities. I have rebooted Power BI (after setting the preview option) and have even rebooted my machine as well as ran Power BI as an administrator and NOTHING is working.  Here are some images of the file I am working on using Version: 2.90.782.0 64-bit (February 2021).

     

    Options:

     

    Parameter Setup:

     

    Table of just values like the tutorial suggests:

     

    Relationships and missing Bind to parameter:

     

    The Query where I need it:

     

    Ideally I want to use the same extracted data from Excel as the Slicer uses.  Am I missing something here?

  • ykannan's avatar
    ykannan
    Helper I
    5 years ago

    More Info:
    I enabled Dynamic M Query Parameters
    Screen shot of model view which miss the Bind To Parameter option

    Also I tried to export data to Excel and used that as source. Still not able to see tht Bind option.
    My Need is to get sales data for selected date(s) by user in service in Direct Query method

  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    ykannan 

    Have you enabled it under Preview options?

    ________________________

    If my answer was helpful, please consider Accept it as the solution to help the other members find it

    Click on the Thumbs-Up icon if you like this reply 🙂

    YouTube  LinkedIn

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

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Community Support
    5 years ago

    Hi ykannan ,

     

    It also didn't work in excel based on my test, since it is in preview status, so the feature may not be fully developed yet. You may have to wait until this feature is officially released.

     

    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