Forum Discussion
Missing columns in data view when click close & apply
Hi both, thanks for offering help. I've managed to resolve this, the model had automatically renamed the field to align it with what I have in the dataverse, so it doesnt now match what I have in Power Query. It was difficult to find as I have many columns in that table, but saw someone had experience similar in another thread.
Hi, sparker95
You can try adding a blank column next to the column in Power query that is having problems, and then move back the two columns that you disappeared to see if that fixes the issue.
If you are using Excel, try converting it to xlsx format.
Solved: MIssing last column in Power Query - Microsoft Fabric Community
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi I'm using it within PowerBI. I tried this solution but it didnt work.
Hi, sparker95
Thank you very much for the description, can you describe what these two fields are in Power Query? Parameter? Or a column in a table? If it's a column in a table, what are their types? It would be of great help to me to judge it if I could provide some screenshots that don't contain sensitive information.
Best Regards
Jianpeng Li
In my power BI power query, for every user, will have the 5 attributes from Jan to July. I check for one user. There are 5 attributes and all of them match with my raw csv data no matter before and after the pivot table for every month and attributes (just to ensure its import correctly).
However, after applied and close my chart cant show the correct value, and ESPECIALLY FOR attritubes1 and attritubes12, two attributes and the rest of are correct. Then I realize, in the table view, i filter for the same user, all the attributes having 7 (1 month 1 attributes) EXCEPT FOR the affiliate order and item sold. attributes1 missing for jun and jul, attributes2 missing for jan - may. This also match the lost value in the chart (For example, so far affiliate order suppose result should be 70, but now its showing 68, maybe due to the missing month for jun and jul with value = 1 for both month). I wondering is this the reason that cause my chart didnt show the correct value for this 2 attribute. s How to solve this problem about missing value in table view, cause since each value exist for every month and 5 of the attributes in power query, but the data and value no complete in table view