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 wh...
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

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