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 used the paste Query window in the import mode but when I converted the query to a View and imported the data showed. I need to change the data source to a view but it is breaking the work I have done.
I dont have any applied steps in the source.