Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Thanks.
This is what I am doing already.
Is there is a way to pre filter before loading the data to transform data ?
@enath
Sorry, that is the only place to filter.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
thee thing is that importing the data and filter it is super super long........
@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/
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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?
@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.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |