Before the data import for {Table Name} finished it's data source timed out.

Hi. It sounds like you data source is too slow for direct query and it throws a timeout before solving the visualization. Direct Query can't be applied with every database engine or scenario. Which is your data source? is it cloud or onpremise?

 

I would recommed the following readings for Direct Query:

Limitations: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery#limitations-of-directquery

Implications: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about#implications-of-using-directquery

Design Model for Direct Query: https://docs.microsoft.com/en-us/power-bi/guidance/directquery-model-guidance

 

The last one it's the most important to get a good performance. I always recommend using import data to my users except for really specific scenarios or requirements because it's not that easy to make it work properly.

 

I hope that helps,

Hi  AnandNamburi ,

You can use Clear Cache in the Options and setting-Data Load of your report, publish to My Workspace to refresh, if successful, publish to the correct Workspace.

 

This is the related document, you can view this content:

https://community.powerbi.com/t5/Issues/Scheduled-Refresh-Fail-Before-the-data-import-for-xxxxxxx/idi-p/666201

https://community.powerbi.com/t5/Issues/Intermittent-refresh-failures-Data-source-timed-out/idi-p/657701/highlight/true#comments

https://community.powerbi.com/t5/Service/Connect-Athena-with-Power-BI-Before-the-data-import-for-finished/m-p/2002395

https://jd-bots.com/2021/03/21/fixed-before-the-data-import-for-finished-its-data-source-timed-out/

 

Best Regards,

Liu Yang

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