Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 data (not in Table format).
I have two examples that follow:
After transforming the data in Query Editor the data appears as so:
However, when I close and apply...the data displays incorrectly. I am still able to pull data into visualizations correctly. It appears the data is only mis-represnted in the data window. As you can see below there are no $5000 amounts in the 3rd and 4th columns.
Another example:
After transforming the data in Query editor I recieve this view:
The data is displayed correctly above...starting in the first row. However, when viewing in the data window, there is now data in the first row.
Upon scrolling 240ish rows down in the data window, I can find the data...but, it is in an odd fomat from what I transformed it to in the Query editor. As before though, the data itself is working fine when applied to visualizations.
Any help with this would be much appreciated!
Best,
Jon
Hi @jrb99,
Could you please mark the proper answer if it's convenient for you? That will be a help to others.
Best Regards!
Dale
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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |