Forum Discussion

jrb99's avatar
jrb99
Frequent Visitor
9 years ago

HELP: Data screen not showing queried data correctly.

I am having an issue with the way data is being displayed in the data tab compared to what I see in the Query Editor after transforming data.  I will mention that I am using basic Excel spreadsheet d...
Need Help
jrb99's avatar
jrb99
Frequent Visitor
9 years ago

Hi Dale,

 

Unfortunately that did not fix the first issue.

 

I think it has to do with the file I am importing, because I haven't had the issue before (though I always try to import tabled data).  I am importing a file that is protected and from a third party source.  Therefore, I can not alter the file to create the tables I would like in the data source.  The best I can do is copy and paste the data into a seperate excel file of my own, which would reduce the automation.

 

Best,

Jon

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi jrb99,

 

Maybe the cause is the source workbook. As we can see from the pictures in your first post, the date of the first 5000 is September 1 2025 while there is only March 01 2025 in the second picture. Maybe it isn't in the picture.

 

Best Regards!

Dale