Forum Discussion

Tafkat's avatar
Tafkat
Frequent Visitor
4 years ago
Solved

Not able to remove table/dataflow from datamart

Hi, 

 

At the moment im working with the new datamart preview.

I Added two datasources both are dataflows.

The thing is I want remove 1 of the 2 dataflows but im not able to find the button remove table or something similar.

 

Am I overlooking something very simple?

 

Thanks for your help!

  • Go to Transform Data in the datamart, right click the query you don't want to load anymore as a table then select Delete, then Save button at the bottom right. Your datamart will be reprocessed. Make sure to materialize (i.e. load) at least one table though, otherwise you'll get this error:

     

3 Replies

  • otravers's avatar
    otravers
    Community Champion

    Go to Transform Data in the datamart, right click the query you don't want to load anymore as a table then select Delete, then Save button at the bottom right. Your datamart will be reprocessed. Make sure to materialize (i.e. load) at least one table though, otherwise you'll get this error:

     

  • I can't seem to find the article but I believe this is a current limitation. Instead for now, can you change the underlying M code to create a table with one column and no rows for now? At least this way you will not be creating a table with data you don't need, you would just get a  single table and column, that you ca delete later when it's available.

    Hope this helps.