Forum Discussion

Enigma's avatar
Enigma
Icon for Helper III rankHelper III
6 years ago

Redundant tables in model

Hi,    I have several tables in my report that are redundant once the data is transformed in Query Editor. And I am looking for ways to minmise the performance impact   Here's the situation: The...
Need Help
v-eachen-msft's avatar
v-eachen-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Enigma ,

 

You could create a folder and put 10 excel files into it. Then import data from folder.

Click "Combine and Transform Data", you will get one tables based on ten files. And you could keep rows/columns you need.

 

Enigma's avatar
Enigma
Icon for Helper III rankHelper III
6 years ago

This looks interesting. I shall try this and see if it works for my model.

Thanks for suggesting, v-eachen-msft !