Data Refresh Timeout

[Chrisss14]

Hi All,

I have a report which uses a connection to Dataverse in DirectQuery mode. It's currently just the 1 table it needs to load data from but it takes so long to refresh and ends up timing out with the below error in Desktop and Service. Has anyone else faced this issue? 

Thanks

[lbendlin]

This has nothing to do with a refresh. It's a Direct Query. The query itself is taking too long because of poor performance of your data source.  Direct Query queries ideally should return data after maximum five seconds.