Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Oracle source- Import Mode - schedule refresh timeout

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 ref...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

 

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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ,

     

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi Anonymous ,

         

        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