Sharepoint refresh time out

[MostVIP2023]

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,would you pls advise me why?How to solve it?

[Anonymous]

Hi, @MostVIP2023 

For data refresh timeouts, perhaps you can refer to the following documentation, which may be able to solve your problem:

PowerPivot for SharePoint 2016 scheduled data refresh fails with the error The operation has timed o...

Troubleshoot refresh scenarios - Power BI | Microsoft Learn

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MostVIP2023]

Hi  yohua,

Thanks for your reply, but I'm not using workbook,just excel....so it's not a solution to me.

[Anonymous]

Hi, @MostVIP2023 

Maybe you can check the following link:

Speed/Performance aspects – (thebiccountant.com)

It will help you learn more about the aspects of improving performance.

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Use Binary.Buffer to speed things up.

[MostVIP2023]

Hi @lbendlin ，

Thanks for your quick response,could you pls show me the details?

[lbendlin]

Show the query part where you fetch the Sharepoint data.

[MostVIP2023]

Hi  @lbendlin ,

Pls check below:

[lbendlin]

the step where you actually fetch the file contents.

[MostVIP2023]

Hi  @lbendlin ,

I marked in red line,pls check.

[lbendlin]

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]

Hi @lbendlin ，

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

[lbendlin]

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

[MostVIP2023]

No, taking long time to load data.....