Forum Discussion

PBI_Inquisitor's avatar
PBI_Inquisitor
Icon for Advocate I rankAdvocate 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 wh...
Need Help
  • PBI_Inquisitor's avatar
    PBI_Inquisitor
    6 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

Anonymous's avatar
Anonymous
Not applicable
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