Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Dynamic Parameter - MYSQL

Hi , 

     I've been trying Dynamic Parameter as Filter to be implemented in MYSQL. It has to be done through Direct Query only. But MYSQL supports only Import Mode. But as alternative solution i've tried calling dataset from Power BI dataset, as it acts as Direct query (Live Connection). But i couldn't implement this. Kindly suggest some workaround solution. 

 

Thanks in Advance!


 

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi @ibendlin
                  I can't get your answer because, in my above statement i've mentioned that i've been trying with MYSQL Database. Seeking your solution based on my query. 

       

      TIA!

      • lbendlin's avatar
        lbendlin
        Super User

        Use the MariaDB connector to connect to your MySQL database in Direct Query mode.