Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi PBI Team,
We are facing an issue in power bi service as well as in desktop app. We have huge amount of data available in tables (>10GB). We are importing data using SQL Server database. Previously, we have only 50k records but now it has more than 500millions rows. Now when we are trying to refresh the data, we are getting below error -
Power Bi Service (Screenshot Attached)
Power Bi Desktop Issue -
Error Description -
Microsoft SQL: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. This failure occurred while attempting to connect to the routing destination. The duration spent while attempting to connect to the original server was - [Pre-Login] initialization=217; handshake=664; [Login] initialization=0; authentication=0; [Post-Login] complete=217;
Appreciate your quick help on this.
In your query source settings there's an option to specify a timeout that is longer than the default one. But it looks as though even doing that would not solve the problem a lot of people in this thread seem to be having because Power BI simply cannot handle such large sets.
I do find it surprising that in the age of "Big Data" things like this haven't been resolved. Just an hour so ago Excel completely fell over when I passed just 500K rows to it
I mean the time out parameter that you set while connecting to any source. You can see that in advance editor M code.
[Timeout=#duration(0, 0, 5, 0)])
I have this same issue. What is the resolution?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
20 | |
19 | |
18 | |
9 |