Forum Discussion
Abnormal data display in Query Editor
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
Have you verified whether you're connecting to the same data source (same server, database, table/view) and not another one with the same schema? Do you have applied steps in the query editor other than data source connection that might be causing the issue? Are there data left if you filter out the nulls?
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.
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
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