How to dynamically fill the Web.Contents function?

[Anonymous]

Hi Everyone!

Concerning a Web.Contents post call with authorization. How can I let power BI (when trying to make a connection/refresh on the report server) statically evaluate "foo.bar.com/@@login?camefrom=%2F%40%40index" but upon execution the following code should be executed? 

Source =  Csv.Document(Web.Contents(foo.bar.com, [RelativePath="export/download",Headers=header,Content=Text.ToBinary(body)]),[Delimiter=";"])

(When logging in "foo.bar.com" is redirected to "foo.bar.com/@@login?camefrom=%2F%40%40index", that's why... in Desktop it all works fine however)

Thanks!

[Anonymous · Accepted solution]

Hi @Anonymous ,

Maybe you can try the solution from this post:

Solved: Using Web.Contents with dynamic Google Sheet URL - Microsoft Power BI Community

Google Sheet URL as an example:

1. In Power BI Desktop, need to go to Option > Privacy and select "Ignore Privacy Level Setting"
2. In Web.Contents, use relative path to work in Power BI Service as well
3. In Web.Contents, use "https://docs.google.com" as the basic URL and put the rest in RelativePath.

(FileID as text) =>
let
    //FileID = "Google Sheet File ID",
    BasicURL = "https://docs.google.com/",
    RelativePathString = "spreadsheets/d/" & FileID & "/export?format=xlsx",
    Source = Excel.Workbook(Web.Contents(BasicURL, [RelativePath=RelativePathString]), null, true)
//    Source = Excel.Workbook(Web.Contents(BasicURL&RelativePathString))
in
    Source

Best Regards,

Stephen Tao

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