Updating Dataset in PowerBI Service without using PowerBI desktop

[Anonymous]

So I have a report that I created in my PowerBI desktop and published to the PowerBI service for sharing. I have scheduled my dataset to be refreshed daily in the options in my workspace. 

However, I created a new calculated column to report off of my date from and I want to have that change reflected in my published app in the service. The problem with making the change in the desktop means I have to then publish the app and overwrite all of my data already loaded into the service. 

I don't want to load months worth of data back into my desktop version. Is there a way to edit my dataset in the service version or somehow avoid having to load months of work of data back into my desktop version for one small calculated column added?

Thanks in advance for the help! 

[v-danhe-msft]

Hi @Anonymous ,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?

Regards,

Daniel He

[zoloturu]

@Anonymous,

What will be overwritten in case you edit the report in Desktop? Do you use Power BI Premium and incremental refresh? Please explain in more details your concern.

Regards,
Ruslan

[Anonymous]

Hi Ruslan @zoloturu

No I use PowerBI pro and the desktop version. I ended up just refreshing my data in my desktop version and then publishing to the Pro service and updating my app that way. It appears there is no way to edit your datasource (e.g. calculatued column) in the PowerBI pro service view- only in the desktop.

Thanks,

Rachel

[v-danhe-msft]

Hi @Anonymous ,

Based on my research, maybe you could use the Dataflow in power bi service to add a column with M query:

https://docs.microsoft.com/en-us/power-bi/service-dataflows-create-use

Hope it could help you.

Regards,

Daniel He

[v-danhe-msft]

Hi @Anonymous,

Based on my test, you have to load your data to your desktop if you have to create a calculated column and there is no way to edit your datasource in Power BI Service.

Regards,

Daniel He