pre filter data before import to power BI (xml & json)

[enath]

Hello

I have a folder with data with many different format.
I would to pre filter my data in order to take only xml or only json before loading the data in the power BI. 

Thanks for your help.

[enath]

Thanks.
This is what I am doing already. 
Is there is a way to pre filter before loading the data to transform data ?

[Fowmy]

@enath 

Sorry, that is the only place to filter.

[enath]

thee thing is that importing the data and filter it is super super long........

[Fowmy]

@enath 

Not quite sure how the process takes so long for you. Anyhow, you can create an idea share you thought here: https://ideas.powerbi.com/ideas/

[enath]

there is so many data and not only json or xml... so the import is too long.

Is there is a way to prepare a dataset via python and then to insert the dataset in the power BI?

[Fowmy]

@enath 
Hope you are using the FOLDER connector to connect to the location. when you connect and click transform in the preview window, you will see the first screen in power Query, click on the extension column and filter the file types you need to use.