Timeout issue for sharepoint list in powerbi service

[WinterGarden]

Hi All,
I am getting a timeout error while refreshing the dataset in powerbi service.

:Tasks" is a sharepoint list.
I wanted to add the timeout code [Timeout=#duration(0,0,36000,0)] in the below code.
can some one help me with this:

[Anonymous]

Hi @WinterGarden 

Here's how you can incorporate the timeout code into your existing Power Query code:

Open your Power BI Desktop file where you've connected to the SharePoint list.

Click "Transform data" to access the power query.

In the “Advanced Editor“ you can add a timeout parameter to the SharePoint list source step.

After you have made this change, save your query changes and try refreshing the dataset again in Power BI Desktop. 

Regards,

Nono Chen

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

[WinterGarden]

Hi,
I've added [Timeout=#duration(0,0,36000,0)] in first step in advanced editor, but it was throwing error. please find the below code and error message for the reference.

Expression.Error: 'Timeout' isn't a valid SharePoint List option. Valid options are:
ApiVersion, DisableAppendNoteColumns, Implementation, ViewMode

[Anonymous]

Hi @WinterGarden 

As the error message indicates, the "Timeout" option is not a valid parameter for SharePoint lists.

"Timeout" is used for Web data sources or SQL queries to specify how long the system should wait before timing out.

If you are using a web source or SQL database and need to set a timeout, you can add a "Timeout" parameter to the corresponding function call. For example: 

let
    Source = Web.Contents("http://example.com", [Timeout=#duration(0, 0, 36000, 0)])
in
    Source

I performed a query on the document and if I get a timeout error when refreshing the dataset in the Power BI service that is connected to the SharePoint list, it could be due to one of the following reasons:

Network issues: There may be connectivity issues between the Power BI service and the SharePoint server hosting the list.

SharePoint list size: If the SharePoint list is very large, the time taken to retrieve and process the data may exceed the service's timeout limit.

Shared capacity: If you use shared capacity in Power BI Premium, the available resources may not be sufficient to process large amounts of data in SharePoint lists.

Data Model Complexity: Data Model Complexity: The data model associated with a SharePoint list may be complex, resulting in longer refresh times.

Timeout Configuration: As mentioned earlier, Power BI does not support setting timeouts directly for SharePoint connections. If the underlying data source or data flow has a timeout setting, the timeout setting may be triggered.

Regards,

Nono Chen

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