Dataset Refresh

[Kich254]

Hi,

Found a rather curious thing with the dataset refresh: it only works in lineage view and not on the dataset context at the left panel. Meaning when i refresh and go to the report section under workspace there'll be no change. It'll only take effect when i view from the lineage view.

[lbendlin]

Are you sure it isn't your browser cache playing games with you?  Try the report route in incognito mode.

[Kich254 · Accepted solution]

Excuse my "Noobism" but hadn't seen the refresh icon at the top right on the report sectiction 😯. Now it works. 

One more question: updating rows in the original on-premise data translates to the same in the power bi service on refresh but doesn't happen for newly added columns. Is that how it works? If so how can i go about adding new columns in the original data and not in power bi via the power query?

[lbendlin]

Any changes in meta data will be met with angry outbursts of juvenile petulance by the Power BI service.  Added columns are usually ignored but removed or renamed columns will result in broken visual rendering. The only remedy is a full dataset refresh that includes meta data updates. On Premium you also need to update the app.

[Kich254]

I see. Sorry I din't mention was referring to the desktop version. Found a solution by editing the column count in "Advanced Editor" in power query editor. Thanks for you feedback, much appreciated..