Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
yebenesPW
Frequent Visitor

Setting a scheduled refresh on a Dynamic Data

Hey everyone, 

 

I need to program a schedule but i use dynamic data so i need to use Relative Paths, when i try to do that with the code under i got the error 

 

 

Expression.Error: Se han pasado 3 argumentos a una función que espera entre 1 y 2.
Detalles:
    Pattern=
    Arguments=[List]

 

 

The param url contains something like this "730214/runs/3246632"

 

 

let
    content = "{
		""method"": ""post"",
		   ""body"": {}
	}",

    Origen =  Json.Document(Web.Contents( "https://test.com/test/",
    [RelativePath = url & "/reports/cookie-privacy"], 
    [Headers=[#"content-type"="application/json", Authorization="Bearer " &#"GetToken"()], 
    Content=Text.ToBinary(content)])),
    #"Convertido en tabla" = Record.ToTable(Origen)
in
    #"Convertido en tabla"

 

 

Thanks for your help

1 REPLY 1
Daryl-Lynch-Bzy
Resident Rockstar
Resident Rockstar

Hi @yebenesPW  I don't understand the need for "url" in the relativepath.  What does url contain?  It is possible that Power is generating the following web call?

 

https://test.com/test/https://test.com/test//reports/cookie-privacy

 

This would look better

 

let
    content = "{
		""method"": ""post"",
		   ""body"": {}
	}",
    url = "https://test.com/test",
    Origen =  Json.Document(Web.Contents( url,
    [
       RelativePath = "/reports/cookie-privacy", 
       Headers=[#"content-type"="application/json", Authorization="Bearer " &#"GetToken"()], 
       Content=Text.ToBinary(content)
    ]
   )
  ),
    #"Convertido en tabla" = Record.ToTable(Origen)
in
    #"Convertido en tabla"

 

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors
Top Kudoed Authors