Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi,
I have 8 tables in my model and i am using Import mode. My datasource is oracle and i gave timeout as 3600 minutes. My datset size is 16 MB. Below are the tables and the count.
Schedule refresh will run for 2 hrs and after that it fails. I am a Pro user.
i tried this schedule refresh during daytime as well as night time but it is failing.
Note:My desktop refresh is sucessful whenever i refresh.
I have enabled even additional logging but i dont get any precise message.
table | count |
A | 2268 |
B | 174942 |
C | 1051241 |
D | 4100086 |
E | 1940135 |
F | 36 |
G | 133994 |
Below is the error message
Timeout expired. The timeout period elapsed prior to completion of the operation
The report is working fine with the scheduled refresh in my local machine. But when i use another machine which is a kindof server where we have installed the standard gateway we are getting the timeout issue. Still the scheduled refresh is not working in the server and i have enabled all the ports and domain name settings in the server but i am not sure why it does not work. it cannot connect to db i guess something is blocking and we are not sure what it is . Any ideas? Thanks in advance
Hi @srutiR2403 ,
Have you configured a gateway for it? Can you provide more detailed error messages?
Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
I have installed standard gateway and using that gateway refresh schedule is configured.
Hi @srutiR2403 ,
If you are using the ODBC connector, there is currently a problem. Please try using the Oralce connector, or use the Personal Edition Gateway.
Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
I am using Oracle connector to connect. From database I chose Oracle databse and from ther i am giving the servername and query along with timeout vlaue of 3600.
Actually I have other reports which is using the same orale source and refresh is sucessful using the standard gateway. Only this report i am getting timeout error
Hi @srutiR2403 ,
I think it could only be a data modeling issue with this report.
Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
if it is modelling problem then when i refresh using power bi desktop the issue will exist right here the issue happens only for schedule refresh manua refresh is always sucessful.
Hi @srutiR2403 ,
Based on the above information, if you are a Power BI Pro licensee, you can create a support ticket for free and a dedicated Microsoft engineer will come to solve the problem for you.
It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.
The link of Power BI Support: Support | Microsoft Power BI
For how to create a support ticket, please refer to How to create a support ticket in Power BI - Microsoft Power BI Community
Best regards.
Community Support Team_Scott Chang
Yes I have installed standard Gateway and using the gateway to refresh it.
Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Timeout expired. The timeout period elapsed prior to completion of the operation."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.HostingError.Reason","detail":{"type":1,"value":"Timeout"}}],"exceptionCulprit":1}}}
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
89 | |
82 | |
76 | |
64 |
User | Count |
---|---|
142 | |
111 | |
108 | |
99 | |
95 |