It is possible to use Dynamic M query for ODBC or OLEDB connection?

[Anonymous]

Dear Power BI experts,

My porblem is that i am trying Use OLEDB/ODBC connection for getting data to PowerBI

I am able to get the data but the problem is that I want use Dynmaic M Query for User Interaction to allow them to select date.

But If i am using the OLEDB or ODBC connection the "Bind to parameter" is not avaible for date selection

The "Bind to parameter is only enable SQL based connection.

FYI :-I have tried OLEDB and ODBC both in  Query Mode but results are unsatifactory.

I like to get any alternet Solution for User interation .

Kind Regards,

Vandan

[Anonymous · Accepted solution]

Hi  @Anonymous ,

Dynamic M query parameters  (Bind to parameter option) is only available for some Direct Query source.

You can see a list of all currently supported data sources for Power BI that can be used with Direct Query here.

Best Regards,

Liu Yang

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

[Anonymous]

Dear Liu Yang San,

Thanks for your kind reponse,

It would be more helpful if you can suggest me any other possible way to achived the same, "user interection to modify the source query".

Kind Regards,

Vandan

[amitchandak]

@Anonymous , I doubt it support those sources =, it support SQL server and m- Source

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters#considerations-and-limitations