Data Modelling

[This1]

Hi,

is it possible to change existing datasets and change the table relation without actually downloading all the data to the desktop application?

Because it looks a little bit out of touch if you need to download millions of data rows just to change a relation that is not something I would need the data for.

[bcdobbs · Accepted solution]

Yes but only with PPU or premium capacity. Each workspace exposes an XLMA end point which let's you connect to it as if it were an azure analysis service (under the hood it is that). 

You can then connect to it with tabular editor or visual studio to make your changes.

Another option is to use a deployment pipeline and parametise your dataset so your dev/test spaces have much smaller data volumes.