Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
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.
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?!
User | Count |
---|---|
80 | |
74 | |
62 | |
61 | |
46 |
User | Count |
---|---|
108 | |
97 | |
88 | |
81 | |
61 |