Updating server tables don't evaluate and times out.

[Jimmy106]

Hello,

I’m having trouble importing data via a directquery to a SQL server.

I need to change the server my report queries from, to do this I’m editing the data source.  I have 4 tables, 2 are fine but the other 2 just evaluate until timing out.  They are slightly larger but not massive (30k rows), worked with old server fine.

Anyone else had this problem?

Thanks,

Jimmy

[v-xicai]

Hi @Jimmy106 ,

There are several points you can considerate.

1.Based on my test in the latest version 2.70.5494.761 of Power BI Desktop, it works fine. Maybe you can try to upgrade the Power BI Desktop.

2. You can try to use SQL query to limit the data rows, Like code below,

SELECT TOP ( 30000 )

        [t1].[Order Number],

        [t1].[Order Line Number]

FROM   [t1]

3. Go to File-> Options and Settings->Options, you can try to clear cache or change the Maximum value, restart the Power BI Desktop to take the change effective.

Best Regards,

Amy

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

[Jimmy106]

Thanks for your reply Amy,

Managed to start getting the data in by using your tips and breaking it into chunks, but it’s so slow it's unusable. 

Worked fine off the old server, could the new server set up potentially cause the issue?!