Forum Discussion

Pavan_123456789's avatar
Pavan_123456789
Helper III
1 year ago

Assistance Required: SQL Timeout Issue When Connecting Power BI

I’m encountering an issue while attempting to connect Power BI to our SQL Server database. The error message reads: “Microsoft SQL: Execution Timeout Expired. The timeout period elapsed prior to com...
Need Help
nandic's avatar
nandic
Resident Rockstar
1 year ago

Pavan_123456789 ,
1) does connection to database work? Once you enter server name, credentials, do you get to a step to choose tables/views/st procedures? If not, something is wrong with server name, credentials or you need to be whitelisted on database level
2) if came to next step, you can select tables/views/st procedures. However, when you try to retrieve data from database, it returns error. Check with database developer who built stored procedure if it works fine on database, maybe you need some additional parameters.

But it seems that this is related to database connection.

Cheers,
Nemanja

  • Pavan_123456789's avatar
    Pavan_123456789
    Helper III
    1 year ago

    Hi nandic ,

    Thank you for your response.

    I was able to load data successfully for a single month, but when I attempt to load the complete dataset, I encounter the error previously mentioned. Could you please advise on potential solutions or adjustments I should consider to resolve this issue?

    Thank you for your guidance.