Forum Discussion
MostVIP2023
2 years agoHelper I
Sharepoint refresh time out
Dear Experts, I have a datasource from Sharepint Online,when I connect it in desktop, the refresh is ok,but when I publish to Service and set the refresh shedule, it always returns time out,w...
lbendlin
2 years agoSuper User
Oh, you are using #"Transform File" - that is unfortunate. You will want to eliminate that part and do the ingestion yourself.
But in general it would be this:
#"Transform File"(Binary.Buffer([Content]))
MostVIP2023
2 years agoHelper I
- lbendlin2 years agoSuper User
That's the right spot. If you can, refactor the query to get rid of the boilerplate #"Transform File".
- MostVIP20232 years agoHelper INo, taking long time to load data.....