Disconnect a filtered table from it's parent table

[gtamir]

Hi, created a filtered new table. It is filtered by a value in one column.

Now I don't need the old table and I want to delete it. I can't do that because the new table is dependent on it.

Is thare a way to make the filtered table independent?

Thanks Giora

[v-yuezhe-msft]

@gtamir,

Did you create the filtered table using DAX? If so, we can create a table visual and put all columns from the filtered table in the Values. After that we can export all the data in the table to a csv. Then we can import the csv to desktop, then a totally independent table will be created.

 

In addition, we can filter the old table in query editor directly rather than creating a new filtered table.

Regards,
Lydia

[gtamir]

Thanks Lydia.

The first is long way to do every month with 6 files.

The second might be good if I could enter a fixed list of values to filter. But the wat I know is to tick each value seperatly. Also long procedure every month.

Giora

[gtamir]

There is another question in this area. I appended 6 files into Sales file. Now I want to delete those 6 files but it won't let me. So my project wights twice. 

[v-yuezhe-msft · Accepted solution]

@gtamir,

Here I suggest you to get the data from a folder, then we can combine all tables directly.

1. Put your 6 files in one folder.
2. Get data -> Folder -> enter the folder path - > load
3. Edit queries -> click the icon on the right side of Content column and choose the sheet we need to combine files.

 

After that, we can get a table that we need:

Regards,
Lydia

[gtamir]

Thanks, good solution.