Edit a dataset in power BI service

[lekkerbek]

Hi,

When I get data from an Excel file I'm able to reshape that data before creating reporting. For example unpivot columns, etc.

Is the same thing possible in app.powerbi.com? I'm able to upload a dataset, but I can't find the editing possibilities like unpivotting columns.

[Sean · Accepted solution]

@lekkerbek

Nope use PBI Desktop for this!

https://powerbi.microsoft.com/en-us/desktop/

Do all creation/editing in the Desktop still!

Check this article by @MattAllington "all that glitters is not gold"

http://exceleratorbi.com.au/save-pbix-power-bi-service-under-delivers/

Hope this helps.

Good Luck!