Forum Discussion
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 possa filtrar os dados de venda através do dashboard e esses dados sejam utilizados como parâmetro na consulta SQL que conecta ao banco. Como faço essa configuração?
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!
1 Reply
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!