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

[StephenF]

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?

[Anonymous]

Hi  @StephenF ,

Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

Best Regards

[StephenF]

It hasnt.

[Anonymous]

Hi @StephenF ,

Please refer the following links to connect to your csv file using web connector instead of csv connector:

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

You should be able to source from an excel file in your sharepoint by doing GetData->From Web then pasting the link to your excel file.

---

Power Query Relative Path for OneDrive and Other Users

Best Regards

[StephenF]

That wont work, i cant add basic credentials .

Web.Contents only ccepts anonymous credentials.

[Anonymous]

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