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
v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

jrb99

 

Hi Jon,

 

It may be the cache that lead the wrong display of the example one. We can clear the cache as the picture showed. After this, we could refresh data.

It's a good practice to format range to table in excel file. A table has clear border of rows and columns. Reference: powerbi-learning-5-2-upload-excel and powerbi-service-excel-workbook-files

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

  • 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