API Help

[Wensley_Dyckson]

Hello, how are you class?
I ask for help to connect the PIB in the Public Revenue WS API.

The API URL is https://www.receitaws.com.br/v1/cnpj/17794044000133

When I unify it in the standard query using the routine below,

• Step = Table.AddColumn(PreviousStep, "NewColumnName", each Json.Document(Web.Contents("https://www.receitaws.com.br/v1/cnpj/17794044000133")))

The PBI gives me this error and I can't import it so I can make it dynamic.

• Formula.Firewall: Query 'dCadastroCLientes' (step 'Step') references other queries or steps, so it may not have direct access to a data source. Recompile this data combination.

API Website:  

[Anonymous]

Hi  @Wensley_Dyckson ,

You can try File - Options -Select Privacy, and if it's appropriate, select Ignore privay levels.

For more information, please refer to the following link:

https://community.powerbi.com/t5/Desktop/Formula-Firewall-Query-references-other-queries-so-it-may-n...

https://www.thepoweruser.com/2019/03/12/data-privacy-and-the-formula-firewall/

https://aforanalytic.com/power-bi-query-references-other-queries-or-steps-so-it-may-not-directly-acc...

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.