cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

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 ?

6 REPLIES 6
Microsoft
Microsoft

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

 

Microsoft
Microsoft

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

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?

Super User IV
Super User IV

@ykannan 

Have you enabled it under Preview options?

Fowmy_0-1606068400984.png

________________________

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

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Website   YouTube    LinkedIn

Yes, I enabled already

New Member

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

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

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors