Forum Discussion

GrahamR99's avatar
GrahamR99
Resolver I
2 years ago

Timeout on Auto refresh

Hello We have serveral Power BI reports on the Power BI Service that are shared, they auto refresh every day, however most days the timeout, with this error; {"error":{"code":"DM_GWPipeline_Gateway...
Need Help
PijushRoy's avatar
PijushRoy
Community Champion
2 years ago

Hi RoopaR GrahamR99 Anonymous 

Sometimes timeout issues occur, due to the server being busy.

When Power BI reads the table, at the same time same table is used to write data or other reports reading data from the same table.
Please look into the data model which table uses same time refresh, optimize your report, how much time it takes when the server is not in use, etc
If you face the same issue, please try to connect to Microsoft support

If solved your requirement, please mark this answer as SOLUTION.
If this comment helps you, Like 👍 this comment 

Thanks
Pijush

  • PijushRoy's avatar
    PijushRoy
    Community Champion
    2 years ago

    Hi @RoopaR @GrahamR99 @alex_j 

    After troubleshooting the below information, 
    When Power BI reads the table, at the same time same table is used to write data or other reports reading data from the same table.
    Please look into the data model which table uses same time refresh, optimize your report, how much time it takes when the server is not in use, etc

    If you face the same issue, please try to connect to Microsoft support
    If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
    Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .

    If solved your requirement, please mark this answer as SOLUTION.
    If this comment helps you, Like     this comment 

    Thanks
    Pijush