Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I have created blank column in Power Query by using the following step.
#"Added Custom" = Table.AddColumn(#"Sorted Rows", " ", each "")
However, I don't want this column to appear in the final results. Is there a way to hide the column when the data is closed and loaded?
Transpose option doesn't help to hide the column. Thank you!
Solved! Go to Solution.
Hi @vineshparekh, if you do not need this column in final result, just delete it.
hi @vineshparekh ,
to hide a column once loaded into the model:
1. select the elipsis:
2. hide
regardless, i agree with @dufoq3 , if you don't need the column, might as well remove it in power query before loading.
hi @vineshparekh ,
to hide a column once loaded into the model:
1. select the elipsis:
2. hide
regardless, i agree with @dufoq3 , if you don't need the column, might as well remove it in power query before loading.
Hi @vineshparekh, if you do not need this column in final result, just delete it.
Hi @dufoq3
I have PDFs coming each month and this query adds a column for the current month invoices.
For example,
Feb/24 and the next month it will add a column automatically with Mar/24 based on invoice. After the last column, I have few columns in Excel (Not connected to query) where it shows formula. Since there is a division between two sets of data, the query doesn't use the same format I provided for the table to the new column. (Mar/24). I have to do the same formatting for the newly added column. Where as, if I have a blank column, the query applies the format to the new column keeping blank column at last.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.