Microsoft SQL: Server provided routing information, but timeout already expired. Table: Dwh......

[Kevin_Conseil]

Hi everyone,

• When trying to refresh my dataset on Power BI service using the "Refresh Now" button or the "schedule refresh" one, it takes quite some time and ultimately give an error message such as follow:
  "Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.Microsoft SQL: Server provided routing information, but timeout already expired. Table: DwhPostingDate."
• The refresh on power bi desktop of the dataset is working fine and do not take more than 40min.
• Publishing the dataset to its respective Power BI service workspaces works fine as well

Troubleshoot done without any success:

• I have setup the timeout in the query editor of my dataset for the query i m having to a database to 180min following this thred (https://community.powerbi.com/t5/Service/Power-Bi-Service-Refresh-timeout-expiration-issue/td-p/1648...)
• I have scaled up my database performance to the max I could get

Anyone having any idea how i could fix this issue?

[Icey]

Hi @Kevin_Conseil ,

If you have Power BI Pro license, I suggest you create a support ticket to get further help.

Best Regards,

Icey

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