How can you edit a manually created table in the service?

[Anonymous]

The dataset is in the service, this is where we work on with Tabular Editor 2. I need to add one row to a table that has been manually created but I am not succeeding.

I've tried to generate the table as I'd like it to be in desktop. Copy the compressed piece of code in TE2 Parttitions and paste it into the service dataset. This was then saved and refreshed using TMSL. Yet nothing I do seems to impact the data of this table. I've looked in the .bim file and nothing to be seen there either.

[Anonymous]

Hi @Anonymous ,

You can't do this in Power BI Service, it's by design.
There are known limitations：

• If you use the Paste or manually enter data option, there’s currently no way to update the data later. If you want to add, modify, or delete data later, you need to go through the Create workflow again and get a new report.

For more information，you can refer to：Create quick reports in the Power BI service 

Best Regards,
Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

I've ended up replacing the partititon code with a PowerQuery #table() step where I've manually entered the data as an array. This was then pushed to the service by using TE2 C# TMSL script with type = "full". This worked.

Too bad it can't be changed manually in a less time consuming manner. 

https://blog.crossjoin.co.uk/2016/06/03/creating-tables-in-power-bipower-query-m-code-using-table/

https://docs.microsoft.com/en-us/analysis-services/tmsl/tabular-model-scripting-language-tmsl-refere...