Forum Discussion

gsrikar33's avatar
gsrikar33
Icon for Advocate II rankAdvocate II
2 years ago
Solved

'bind to parameter' option is not showing even when I used DirectQuery to get data.

Hi All,   I am trying to create parameters for Year and WeekOfYear in Power Bi report. Though I can create a calendar table in the powerquery itself, I am using Directquery and fetching the values...
Need Help
Show and Tell
  • gsrikar33's avatar
    gsrikar33
    2 years ago

    Thanks everyone for the assistance!
    Checked this link.
    MySQL is not mentioned in that link.
    'Bind to parameter' option will appear only for 'Direct Query' storage mode only.

    For MySQL, 'Direct Query' menthod can only be used with MariaDB's ODBC driver. But we will not be able to write queries with this driver. We can only browser the database and select tables.
    Workaround to write queries with this driver is to create a view in the database and use it.

     

    Upon further testing I could see that this Maria DB driver is not great and I couldnt develop atleast one report with DIrectQuery method using this.

     

    Where as I could do direct query with SQL server database source. This works perfect though.

gsrikar33's avatar
gsrikar33
Icon for Advocate II rankAdvocate II
2 years ago

Thanks everyone for the assistance!
Checked this link.
MySQL is not mentioned in that link.
'Bind to parameter' option will appear only for 'Direct Query' storage mode only.

For MySQL, 'Direct Query' menthod can only be used with MariaDB's ODBC driver. But we will not be able to write queries with this driver. We can only browser the database and select tables.
Workaround to write queries with this driver is to create a view in the database and use it.

 

Upon further testing I could see that this Maria DB driver is not great and I couldnt develop atleast one report with DIrectQuery method using this.

 

Where as I could do direct query with SQL server database source. This works perfect though.