Forum Discussion
Power Bi Report Builder - Conexão Lista do SharePoint
Prezados(as),
Estou utilizando a v15.7.1813.16 do Power Bi Report Builder e na mesma estou montando um relatório utilizando como fonte o SharePoint (conexão direta), mas não estou conseguindo adicionar parametros para a fonte de dados.
Ao utilizar o método de conexão supracitado, o Designer de Consulta fica desabilitado e assim não consigo adicionar o parametro a fonte de dados, assim o mesmo não aplica os filtros desejados.
Tentei adicionar um paremetro no Power Query do Resport com o mesmo nome de parâmetro criado internamente, mas infelizmente não obtive sucesso.
Ex.:
Hi, samuel17sp
Thank you very much for your inquiry. Because when you use the Get data feature in Power Query builder, you are calling the online Power Query online service, so the button is displayed but not clickable:
This is by design for Power Query online. If you want to re-edit these queries, you should click on the edit mashup:
If you want to filter your dataset using the fields in Report builder, you should set it up as follows, considering that you are calling Power query online:
Here are the results:
In fact, if you set an internal parameter in a query in Power Query Online, it will not be recognized and mapped by the parameters in Power BI report builder. Here's the difference between an online service and a local connector called:
This is very normal behavior. Different connectors recognize the parameters in Report builder differently, and you should respect these connectors.
You should use the method I provided above. It correctly filters queries in SharePoint.Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi, samuel17sp
Thank you very much for your inquiry. Because when you use the Get data feature in Power Query builder, you are calling the online Power Query online service, so the button is displayed but not clickable:
This is by design for Power Query online. If you want to re-edit these queries, you should click on the edit mashup:
If you want to filter your dataset using the fields in Report builder, you should set it up as follows, considering that you are calling Power query online:
Here are the results:
In fact, if you set an internal parameter in a query in Power Query Online, it will not be recognized and mapped by the parameters in Power BI report builder. Here's the difference between an online service and a local connector called:
This is very normal behavior. Different connectors recognize the parameters in Report builder differently, and you should respect these connectors.
You should use the method I provided above. It correctly filters queries in SharePoint.Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.