Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Sharepoint dataflow connections refresh timing or taking alot longer than usual

Submitted by Anonymous on ‎01-16-2023 03:35 PM

Hi,

 

Recently all of my dataflows that connect to sharepoint lists as their data sources have started to fail the refresh because of a connection timeout after 30 minutes. This is happening to every dataflow we have that uses a sharepoint connector, even the very small data sources.

 

Error: DataSource.Error: SharePoint: Request failed: The operation has timed out Request ID: 8c5ea314-e747-4407-ba27-9cde41b38337 Activity ID: 7b194910-5641-479f-9a64-e486859150f0

 

We have not made any changes to the dataflows, but the refresh time went from completing within 10 minutes to now timing out and failing after about 30 minutes.
I got an on demand refresh to finally work yesterday but it also took nearly 2 hours to complete.
I have tried refreshing my data credentials, but that hasn't changed anything.

 

We really need this performance to go back to what it was becasue its impacting critical business reporting

Status: Accepted
See more ideas labeled with:
5 Comments (5 New)
Comments
Anonymous
Not applicable
‎01-16-2023 07:38 PM

This is the snapshot of the failed refresh report 

jkah_0-1673926673139.png

 

 

Anonymous
Not applicable
‎01-17-2023 12:04 AM

Hi @Anonymous 

It's a known issue , the engineers are working hard to deal with the problem, please be patient .

 

Best Regards,
Community Support Team _ Ailsa Tao

Anonymous
Not applicable
‎01-17-2023 01:07 AM

Is this related to this other dataflow problem? https://community.powerbi.com/t5/Service/Unable-to-refresh-dataflows-error-occurred-during-the-pre-l... 

 

That and this SharePoint source error started happening for us at the same time.

Ettikudiappan
New Member
‎01-17-2023 10:13 PM

Same issue in my company also. Wondering if it is a known issue, why is all the status on the PowerBI issues page glowing green?

JahidBenhagoug
Frequent Visitor
‎01-19-2023 04:19 AM

Hello, I may have found the solution to the problem.

I had my credentials stored in my sharepoint connection inside the gateway, but when you create a new connection, it automatically enters the adress of the sharepoint site. You have to add a "/" at the end of this address for it to work again, I don't know why.

If someone from Microsoft reads this, please send money and tickets Restau.

Idea Statuses