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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
EiA
Frequent Visitor

RelativePath with Anonymous connection

Hi,

 

I am having issues when I try to combine Chris Webb's explanation on RelativePath with "Anonymous authentication" (works well when I use built in Power BI Basic authentication, and don't have to pass authentication in M)

 

When I pass this M code:

 

let
Source = Json.Document(Web.Contents("BaseURL", [RelativePath= #"DateParameter"],
[Headers=[Authorization=Text.Combine({"Basic ", AuthKeyParameter})]])),
#"Converted to Table1" = Record.ToTable(Source)
in
#"Converted to Table1"

 

I receive: "Expression.Error: 3 arguments were passed to a function which expects between 1 and 2.".

 

Anyone able to help? Thanks.

1 ACCEPTED SOLUTION
Vera_33
Resident Rockstar
Resident Rockstar

Hi @EiA 

 

You passed 3 arguments to Web.Contents...

let
Source = Json.Document(Web.Contents("BaseURL", 
    [
        RelativePath= DateParameter,
        Headers=[Authorization=Text.Combine({"Basic ", AuthKeyParameter})]
        
    ])),
#"Converted to Table1" = Record.ToTable(Source)
in
#"Converted to Table1"

View solution in original post

1 REPLY 1
Vera_33
Resident Rockstar
Resident Rockstar

Hi @EiA 

 

You passed 3 arguments to Web.Contents...

let
Source = Json.Document(Web.Contents("BaseURL", 
    [
        RelativePath= DateParameter,
        Headers=[Authorization=Text.Combine({"Basic ", AuthKeyParameter})]
        
    ])),
#"Converted to Table1" = Record.ToTable(Source)
in
#"Converted to Table1"

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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

Top Solution Authors