Forum Discussion

cchilton's avatar
cchilton
Icon for Helper I rankHelper I
1 year ago
Solved

Refresh issues in Power BI desktop and Power BI Service

My company has three servers (dev, staging, and prod). I have three different Power BI reports (dev, staging, and prod). The reports are identical except for the server where the data is coming from....
  • v-aatheeque's avatar
    1 year ago

    Hi cchilton ,
    Thanks for reaching out to Microsoft Fabric Community Forum.
    lbendlin Thanks for your prompt response.In addition to that :
    Based on the error message you provided, this issue appears to be primarily related to the server rather than Power BI itself.The error message indicates a timeout expired issue, which typically occurs when the SQL Server is unable to complete the operation within the allocated time or is not responding.

    • The SQL Server might be under heavy load or experiencing performance issues. This indicates that the SQL server is taking too long to respond to the query, and the operation is timing out. Optimizing the query or increasing server resources could help.
    • The "Gateway Mashup Data Access Error" suggests that Power BI's attempt to access data through the on-premises data gateway (if you're using one) failed because of the timeout.
    • If you're using an on-premises data gateway, ensure that it's properly configured and has access to the SQL Server
    • If the server is hosted remotely, network latency or connectivity issues could be causing the timeout.

    Additionally you can refer this doc : https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/connect/timeout-expired-error

    If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.

    If you continue to face issues, feel free to reach out to us for further assistance!