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.
The automatic refresh for my report is failing and gives the error "Microsoft SQL: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.". The query is running successfully on MSSMS and there are around 3 million records. Urgent help needed.
Solved! Go to Solution.
Hi, @navas009
It’s my pleasure to answer for you.
According to your description,I have the follow question.
Which data source you connected to?What's your connection mode?Whether it can be refreshed normally in the desktop or whether it can be refreshed normally by using ‘refresh now’ in the service.
Have you tried like this:
If it doesn’t solve your problem, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @navas009
It’s my pleasure to answer for you.
According to your description,I have the follow question.
Which data source you connected to?What's your connection mode?Whether it can be refreshed normally in the desktop or whether it can be refreshed normally by using ‘refresh now’ in the service.
Have you tried like this:
If it doesn’t solve your problem, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Are you transforming something using Power Query ? Or even using duplicate/referencing any query ?
Yes, we are duplicating the records and pivoting the columns
You can try increasing the timeout option:
I have already done that but it keeps on loading and nothing happens
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 |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |