Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Does anyone have any advice as to why my excel data sheet is no longer loading the column header names? It honestly should've just refreshed and updated info but somehow it didn't happen. I have about 2 days of experience on this software and everything I googled has been really hard for me to understand. I have ensured the column in the excel was made into a table so that the drop down boxes appear and that has not resolved the issue either. Please advise.
Solved! Go to Solution.
Hi @frivera
Check the Query Editor and your header may be listed as first row in the data. Click Transform tab, then select "Use first row as headers" option.
Thanks
Raj
Hi @frivera
Check the Query Editor and your header may be listed as first row in the data. Click Transform tab, then select "Use first row as headers" option.
Thanks
Raj
Thanks so much! I had to delete it and re-add the data to be able to get the right results following your steps but it did work.
User | Count |
---|---|
101 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
98 | |
97 | |
73 | |
72 |