topic Re: Missing columns in data view when click close & apply in Report Server

Missing columns in data view when click close & apply

sparker95 — Wed, 04 Dec 2024 11:27:21 GMT

I've got quite a big model and recently I've had two fields dissapear off it that are quite crucial. I can see these fields when in Power Query but as soon as I click close & load they dont appear anywhere. They are not hidden in model view, don't appear in table view and then can't be searched for. I cant see anything in Power Query to stop them loading.

Re: Missing columns in data view when click close & apply

Anonymous — Thu, 05 Dec 2024 01:52:43 GMT

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.

Re: Missing columns in data view when click close & apply

sparker95 — Mon, 09 Dec 2024 17:04:34 GMT

Hi I'm using it within PowerBI. I tried this solution but it didnt work.

Re: Missing columns in data view when click close & apply

Anonymous — Tue, 10 Dec 2024 01:56:22 GMT

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

Re: Missing columns in data view when click close & apply

Vanchy_Liao — Tue, 10 Dec 2024 03:22:28 GMT

sparker95 ,

i assume that you clicked the "Close & Apply" button and PBI didn't trigger "Refresh" event.

if i add a column to my data source, i will:

1. Enter into Power Query -> Refresh Preview -> Check the column

2. Click "Close & Apply" button -> Click "Refresh" button

Re: Missing columns in data view when click close & apply

sparker95 — Tue, 10 Dec 2024 09:12:40 GMT

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.

Re: Missing columns in data view when click close & apply

Anonymous — Tue, 10 Dec 2024 09:32:39 GMT

Thank you ！

Best regard

Re: Missing columns in data view when click close & apply

kncccc — Tue, 02 Sep 2025 08:41:09 GMT

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