Dataset created from Dataflow is showing Refresh Error

[Anonymous]

I have created a dataset (DS) using a Dataflow (DF) and published DS into the Workspace to refresh, but it’s showing the timeout error after refreshing for more than 5 hours. I don't know where to put the timeout value in Dataset when it is created from Dataflow. Can anyone please help? 

[Anonymous]

Hi @Anonymous ,

Sorry to disturb you...

But did I answer your question ? Please mark my reply as solution. Thank you very much.

Best Regards,
Stephen Tao

[Anonymous]

Hi @Anonymous ,

Firstly,  if your dataset is too large,  it will fail to refresh until you filter the data model back down under 1 GB.

Secondly, you may improve the performance for the data model, see Power BI performance best practices , Power BI Performance Tips and Techniques.

And you may try to specify appropriate value in “Command timeout in minutes (optional)" , then check if you can  refresh successfully in Power BI Desktop.

For the above steps, please kindly refer to these two posts:

https://community.powerbi.com/t5/Service/Timeout-Refresh-errors-azure-sql-sources-refresh-time-range-15/td-p/1189151

https://community.powerbi.com/t5/Service/Power-Bi-Service-Refresh-timeout-expiration-issue/td-p/164836

Best Regards,

Stephen Tao

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