Forum Discussion

StephenF's avatar
StephenF
Icon for Responsive Resident rankResponsive Resident
3 years ago

Error: The supplied file path must be a valid absolute path

A path im trying to pull a csv from throws an error.   "The supplied file path must be a valid absolute path."   Whats wrong with this path and how can i fix it?    
Need Help
StephenF's avatar
StephenF
Icon for Responsive Resident rankResponsive Resident
3 years ago

That wont work, i cant add basic credentials .

 

Web.Contents only ccepts anonymous credentials.

 

 

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi StephenF ,

The new Web connector can't be used to connect to a source that requires non-anonymous authentication. This limitation applies to the Web.BrowserContents function, regardless of the host environment. Please find more details in this official documentation. Please try to update the codes in your Advanced Editor and check if it can work.

let
  Source = Web.Page(Web.Contents("<your address here>")),
  Navigation = Source{0}[Data]
in
  Navigation

In addition, please check if the solution in the following thread can be used as an workaround.

Web Connection with Credentials

Power bi cannot just get data from any secured website. The web connector do not pass the username and password to the web to fetch data. As the workaround, if the website expose the REST API, you could use the api method.

Using Power Query to get data from an API that uses a Username and Password combination - Reporting/...

Best Regards