Forum Discussion
dpenny
9 years agoHelper II
changes not being saved ??
I am new to DeskTOP BI but an Excel guru. I thought this would be easy, ha ha ha. The interface isnt easy.... I load a csv from my PC. It seems fine except, header row is being treated as data. ...
parry2k
9 years agoSuper User
You can use promote header to get column header, try this:
- go to query editor
- click down arrow as shown below to open a menu
- Select "Use First row as headers"
dpenny
9 years agoHelper II
Thanks, I've got that now.
BUT
AFter making that change, saving, and exiting the DskTop prog, it is gone when I come back 1 hour later.
why not saved?
- dkay84_PowerBI9 years agoMicrosoft EmployeeDid you hit "close and apply" from the query editor before saving the pbix?
- dpenny9 years agoHelper II
yes I did.
I guess I figured it out. Changes are not saved unless you have built a report. even if/when you hit the "close query & save" button.
can anyone confirm this "feature" (I call it a bug.)
- parry2k9 years agoSuper User
INteresting finding, never experienced this, going to try in next few minutes and get back soon.