Forum Discussion

hyper123's avatar
hyper123
New Member
2 years ago
Solved

Parametros em consulta SQL

Olá, possuo uma consulta SQL de conexão com o PowerQuery que retorna os dados da minha tabela de vendas do banco de dados firebird. Gostaria de configurar um parâmetro de dados para que o usuário pos...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi hyper123 

     

    This is possible with the dynamic M query parameter feature in Power BI. You can read more from Dynamic M query parameters in Power BI Desktop. This feature is only available for DirectQuery source queries. There are several considerations and limitations you need to take into account. You can find them in above document. 

     

    Here is a blog regarding this feature in Power BI community. Hope it would be helpful: 

    Unlock the power of dynamic parameter binding for ... - Microsoft Fabric Community

     

    Best Regards,
    Jing
    If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi hyper123 

 

This is possible with the dynamic M query parameter feature in Power BI. You can read more from Dynamic M query parameters in Power BI Desktop. This feature is only available for DirectQuery source queries. There are several considerations and limitations you need to take into account. You can find them in above document. 

 

Here is a blog regarding this feature in Power BI community. Hope it would be helpful: 

Unlock the power of dynamic parameter binding for ... - Microsoft Fabric Community

 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!