source is azure sql server tables are moving from azure adf piplelines but user is refreshing from powerbi showing mentioned error.

nn 20 Reputation points
2024-08-10T07:33:18.01+00:00

source is azure sql server tables are moving from azure adf piplelines but user is refreshing from powerbi showing mentioned error.WhatsApp Image 2024-08-10 at 12.59.33 PM

Azure SQL Database
{count} votes

1 answer

Sort by: Most helpful
  1. Vinodh247 18,101 Reputation points
    2024-08-10T13:59:17.18+00:00

    Hi nn,

    Thanks for reaching out to Microsoft Q&A.

    The error message in Power BI indicates a timeout issue when refreshing data from an Azure SQL Server. This can happen for several reasons, especially in scenarios where data is being moved via ADF pipelines.

    1. Increase the timeout setting in PBI
    2. Optimize sql queries
    3. Stagger adf Pipeline runs
    4. Check for locked resources
    5. Scaling azure sqlserver resources
    6. Use directqeury Mode (if possible)

    Please 'Upvote'(Thumbs-up) and 'Accept' as an answer if the reply was helpful. This will benefit other community members who face the same issue.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.