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 CSV which i have to edit every day.
In the first row there are some status informations and they are not relevant for the table.
at row 2 the table starts.
But how can i import this in powerquery.
Now my workaround is:
- open it in open office
- remove first row
- import it with powerquery
but is there a better way?
thank you!
Hi @n8schicht ,
The answer given by @ElenaN is a great option but I'm assuming you are not proeficcient in query editor and advance editing, best option would be to just filter out the row 2 from your dataset, when it's uploaded to the model it will only return the last step of your query.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHello,
You can use the function Table.Skip to remove first needed rows. (after loading the initial/unmodified file in Power Query)
https://docs.microsoft.com/en-us/powerquery-m/table-skip
Regards,
ElenaN
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 |
---|---|
107 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |