Forum Discussion

MostVIP2023's avatar
MostVIP2023
Icon for Helper I rankHelper I
2 years ago

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...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

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's avatar
MostVIP2023
Icon for Helper I rankHelper I
2 years ago

Hi lbendlin ，

 

Is something like this? Is there any other part I need to use Binary.Buffer?

 

 

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    That's the right spot. If you can, refactor the query to get rid of the boilerplate #"Transform File".

  • MostVIP2023's avatar
    MostVIP2023
    Icon for Helper I rankHelper I
    2 years ago
    No, taking long time to load data.....