Forum Discussion

mjsystemss's avatar
mjsystemss
Resolver I
4 months ago
Solved

Abnormal data display in Query Editor

Hello, I am having this abnormal behavior in Power Query editor the first. The first screenshot below from Oracle SQL DB. when I import it into Power Query editor it does not display data. It shows...
Need Help
  • v-moharafi-msft's avatar
    v-moharafi-msft
    3 months ago

    Hi mjsystemss ,

     

    Thank you for your patience.

     

    Since you’re working with Oracle Database in Microsoft Power BI.

    Please consider following points:

    • Check or remove the “Changed Type” step, as type conversions can impact how queries are executed at the source
    • Use View Native Query to identify where folding starts causing problems

    You can refer to Microsoft’s official documentation for more details:

    https://learn.microsoft.com/en-us/power-query/query-folding-basics

     

    Best Regards,

    Abdul Rafi

Juan-Power-bi's avatar
Juan-Power-bi
Super User
4 months ago

This is most likely a query folding or data type issue with the Oracle connector.

Perhaps you can see  if you're importing a view or a query with complex logic (CASE statements, functions, etc.), Oracle sometimes returns nulls when Power BI pushes certain operations back to the database that the source can't handle cleanly.
Try adding a step right after Source to disable query folding: Table.Buffer(Source) — this forces Power Query to pull all the data locally before applying any transformations. If data shows up after that, query folding is the culprit.
Also check the data type Power Query assigned to those columns. If it's detecting the wrong type and casting nulls, removing the "Changed Type" step temporarily will tell you if that's the issue.