Forum Discussion
DataVitalizer
3 years agoSuper User
Can't save a dataflow
Hi Community,
I am about to create a dataflow based on a Onedrive folder where my final query will combine multiple files
The problem is when I try to save the dataflow I get the following error message
Any suggestions to get over this?
Thank you in advance
2 Replies
- amitchandakSuper User
- DataVitalizerSuper User
amitchandak Thank you for your time
I tried applying the suggested solution as below
Source= Csv.Document(Web.Contents("https://sharepoint site/personal/user_@domainename",[RelativePath="Documents/Folder/Subfolder",Query=Param]), [Delimiter = ",", Columns = 6, QuoteStyle = QuoteStyle.None]),
Since I the need is to combine a subfolder files, I previously created a paramater "Param", then I added this on in the Query valueOnce I applied I got a new error message "The credentials provided for the Web source are invalid"?!Thank you in advance.