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.
How do I make all of the Fields from my table appear on the left "Fields" bar?
Less than half of my fields show up on the left Fields bar. I think it has to do with the lack of data in the columns. Some columns have are 99% empty one is 100% empty. They are dates for the most part. Is there a way to make them appear?
Solved! Go to Solution.
Solved. In transform data I noticed that the date fields had a question mark next to the calendar. I went into Advanced Editor I replaced "None" with "Date" after all the fields that were dates.
Solved. In transform data I noticed that the date fields had a question mark next to the calendar. I went into Advanced Editor I replaced "None" with "Date" after all the fields that were dates.
Glad you could solved it. please mark you answer as correct.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Brett007 ,
The fileds panel show all the columns no your model (except the ones you hide), it doesn't matter if they have data or not if the column exists it shows up on the Fields panel.
However be advise that this is based on the last step of your query so if you on the query editor delete columns they will not show on your Fields panel.
Check on the query editor if the last step has all the columns you need if not check in what step you have "lost" you columns, may be on a deletion, a group by, a merge and so on.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsJoin the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
62 | |
60 |
User | Count |
---|---|
197 | |
118 | |
108 | |
78 | |
69 |