Forum Discussion

PBI_Inquisitor's avatar
PBI_Inquisitor
Advocate I
6 months ago
Solved

Refresh dataset does not complete when new table added

Hi 

I have a dataset with approx 14 tables imported from Oracle - they refresh daily on a schedule

I now want to add a new table from Oracle but I'm finding that although I can see it in Preview when I Close & Apply it never completes (tries to refresh all data tables on C&A)

Tried closing all Apps on my laptop and even using a VM but I get the same issue - data refresh never completes.

Oracle says there are no active sessions as thinks it has dealt with my request

Currently lost in what to do next so any advice would be great

thanks in advance

Phil

Need Help
  • PBI_Inquisitor's avatar
    PBI_Inquisitor
    5 months ago

    Finally have this sorted but it was by changing a few of the Native Queries to Navigation that sorted the issue. So, rather than writing a Native Query I created a view in our Oracle source and then used Navigation to extract the data.

    Works as required but odd that NQs cause this much of an issue

    Thanks for trying to help me out

9 Replies

  • PBI_Inquisitor's avatar
    PBI_Inquisitor
    Advocate I
    6 months ago

    Thanks for your reply - I'm working with our IT team to see if they can update this as I don't have permission!! will let you know...

    • PBI_Inquisitor's avatar
      PBI_Inquisitor
      Advocate I
      5 months ago

      Finally have this sorted but it was by changing a few of the Native Queries to Navigation that sorted the issue. So, rather than writing a Native Query I created a view in our Oracle source and then used Navigation to extract the data.

      Works as required but odd that NQs cause this much of an issue

      Thanks for trying to help me out

      • v-nmadadi-msft's avatar
        v-nmadadi-msft
        Community Support
        5 months ago

        Hi PBI_Inquisitor ,

        We really appreciate your efforts and for letting us know the update on the issue.

        Please continue using fabric community forum for your further assistance.

        Thank you

  • dk_dk's avatar
    dk_dk
    Super User
    6 months ago

    Hi PBI_Inquisitor 

    If you make a new blank report and connect to only this one table that you are trying to add, does it load?

  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    Community Support
    6 months ago

    Hi PBI_Inquisitor  ,
    Thanks for reaching out to the Microsoft Fabric Community forum.

    For Oracle database to work with Power BI it requires installation of Oracle Client for Microsoft Tools  (OCMT) which installs and configures Oracle Data Provider(ODP)

    One critical configurable setting for the ODP.Net  oracle driver is the "Fetch Size". Oracle ODP.NET  Documentation  - 

     


    "Fetch Size Specifies the total memory size, in bytes, that ODP.NET  allocates to cache the data fetched from a database round-trip.".

    Essentially it determines how much data is fetched per trip to the data source. The default size is 128K. So if you have a report that pulls 10MB of data, it will take 80 trips to the data source to get all the data. Multiply that by 100s of reports and that can become a bottleneck.

    Increasing the value of this parameter can show a significant improvement in performance, especially for large datasets.




    I hope this information helps. Please do let us know if you have any further queries.
    Thank you

  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    Community Support
    6 months ago

    Hi PBI_Inquisitor 

    I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.


    Thank you.

  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    Community Support
    6 months ago

    Hi PBI_Inquisitor 

    May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.


    Thank you