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

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  , 

 

Could you please confirm if the issue has been resolved? If not, feel free to reach out if you have any further questions.

Your update would be helpful for other members who may face a similar issue.

 

Best Regards,

Abdul Rafi