Forum Discussion

Helper II

9 years ago

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. ...

Helper II

9 years ago

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?

Microsoft Employee

9 years ago

Did you hit "close and apply" from the query editor before saving the pbix?

dpenny
Helper II
9 years ago
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.)
- parry2k
  Super User
  9 years ago
  INteresting finding, never experienced this, going to try in next few minutes and get back soon.
  - parry2k
    Super User
    9 years ago
    one thing i'm little confused why you are not getting heading from csv, here is what i did
    
    - click get data drop down
    - selected csv
    - select the csv file
    
    and i get following screen shot and you can see the headers are there:
- dkay84_PowerBI
  Microsoft Employee
  9 years ago
  This sounds like a bug. I've never encountered this before. If I make changes to the data model from the query editor, hit close and apply, and save a blank canvas, when I reopen the file those changes are saved.
- TomEvers
  Frequent Visitor
  9 years ago
  I'm not supprised, changes are not always saved when you do have a report.