Forum Discussion

mjsystemss's avatar
mjsystemss
Resolver I
3 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

mjsystemss's avatar
mjsystemss
Resolver I
3 months ago

I have resolved this. I deleted the table and imported it again. I am still interested to know how to resolve the query folding problem.

v-moharafi-msft's avatar
v-moharafi-msft
Community Support
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