Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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:
(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.
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:
(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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.