Forum Discussion
Power Query Table != Power BI Table
Replicated the query on a csv extract, no problems if it's a connection to csv. Something with the connection/connector is bugged.
It turns out that this particular connector repulls the query at each applied step, and as the query randomizes the data pull every time it breaks the order of items. The solution is to sort at the very top of the query to lock the sort order. This negatively impacts query refreshing and editing quite a bit so heads up on that.
Hi Cherie,
You're partially right, I realized yesterday that Power BI automatically changed that column input to sum. Previously, I believe Power BI would change the field name to "Sum of {FieldName}". After changing it, I was able to find the record, this solves issue #1.
The second issue eludes me however. To give more details - I generate a key involving several columns. For ex:
- Key = Concatenate(ColA, ColB) (not with this syntax though), and I can see the key generated.
- Given the following inputs:
-- ColA, Row1 = 06
-- ColB, Row1 = "RZ"
-- Key = 06RZ
If I filter on just this key in Power Query, every seems fine. I load it and look at it the the data tables, everything seems fine. Then I bring the columns into a Power BI table visual and suddenly 06RZ maps to other ColB values like NT, CV, etc.
Yesterday I was working on solving this problem, then I copied the faulty table to a new tab and suddenly it seemed fine!! Then I went back to the old tab and that one was fine too! Then I proceeded to work more on it and suddenly they were all broken again. Sometimes, I'll recieve a "not enough memory to display" error, so perhaps it's a bug related to limited memory. I'll proceed with that idea and I have a couple more troubleshooting ideas but I've been troubleshooting this one issue for over 21 hours now.
HI SBuri,
Please try increasing the data cache to the maximum limit possible depending on the space in your local machine.
As far as I know if set more than 8 GB, there should ne no issue regarding memory.
Navigation: File -> Option & Settings -> Options -> Data Cache Management Options (Increase this to more than 8 GB)
Regards,
Saurabh Kedia