changes not being saved ??

[dpenny]

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. Dumb program, it is a csv.

Anyway, I used a query to "delete" first row and renamed cols from "colum 1" to appropriate. same to other cols also.

Now the problem, I save it as a pbix file, BUT when I come back and open this file, the header row is present and cols are back to "column1 " etc.  In short, my changes were not save.

Now I am afraid to do anything meaningful since changes are not being save.

Whats up??

[parry2k]

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]

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_PowerBI]

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

[dpenny]

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

[TomEvers]

I'm not supprised, changes are not always saved when you do have a report.  

[dkay84_PowerBI]

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.

[parry2k]

INteresting finding, never experienced this, going to try in next few minutes and get back soon.

[parry2k]

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:

[dpenny]

W/r to headers, that is not my experience. The 1st row in BI was my headers, and above it, BI added a set of column names "column 1" etc etc. These new names are what should up in the visualization construction window. (dont know what else to call it).

I can't easly replicate, cause, I've now built a report, and results of query (to fix 1st row) are now saved.

I may try to upload with a diff file name and see what happens later today.

[parry2k]

sure will be interesting to see, i'm still not clear on your heading part

[dpenny]

I just uploaded a copy of my csv file.

Everything behaves as originally expected:

1. making 1st row to be headers
2. save & close query, then close BI, then open by clicking the pbix file, query changes are present.

Go Figure.

(But there is already one existing report in this experiment. Hmmmm, let me try a brand new BI instance.)