Forum Discussion
Responsive ResidentError: 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?
5 Replies
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.
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.BrowserContentsfunction, 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 NavigationIn 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.Best Regards
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.
