How to use Relative Path ?

[Vialle_Diego]

I'm using an API to bring the state and city columns according to my zip code column. However, to enable auto-scheduling in Power BI Service, I need to use the Relative Path function in Power Query. How to use ?

"This dataset includes a dynamic data source. Since dynamic data sources are not updated in the Power BI service, this dataset will not be updated."

[jbwtp]

Hi @Vialle_Diego,

Interesting... I am sure I used to be able to do paginating HTTP requests in PBI.

Do you want to try to create a separate column which would be complete URL, rather than combining it in the Web.Content function? Maybe this can help.

Kind regards,

John 

[Vialle_Diego · Accepted solution]

I found the answer:

Json.Document(Web.Contents("https://brasilapi.com.br/api/cep/v1/",[RelativePath = [CEP]]))