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

Show the query part where you fetch the Sharepoint data.

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

    the step where you actually fetch the file contents.

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

      Hi  lbendlin ,

      I marked in red line,pls check.

       

      • 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]))