Data Explorer Copy API request to automate on Excel/PowerBI

[Walter2]

Olá Pessoal, estou tentando copiar a API request da métrica criada no Data Explorer para o Excel/PowerBI para que eu possa ter atualizações automáticas da tabela, so que tenho recebido erros a partir do Excel/PowerBI na autenticação do Token.

[rkdy · Accepted solution]

Hi,

I believe you can resolve that error with the following: https://learn.microsoft.com/en-us/powerquery-m/web-contents#example-3 in the case you did not Hard code the Api-Token in the form prior to the one you saw the error in.

I have also attached a screenshot of the form I am referring to: 

[Paulo1989]

thank you rkdy I already figured out