Forum Discussion
How can I import just specific .CSV Column / Row data and not other portions, from a 3rd party file?
Hi There,
I'm wanting to utilise PowerBI to display some statistics from a 3rd party's hasten I add in the public domain and hence usable, data that is contained within their quarterly released .CSV file.
However, 90%+ of the data is containing other sectors of business that I do NOT want the statistics for, in my PowerBI charts or Dashboard that I would like to make.
If you look at the following CSV file: https://ico.org.uk/media/action-weve-taken/csvs/2172893/data-security-incident-trends-201718.csv and the following Column A with ALL Rows and Column C 'Charitable & Voluntary' ALL Rows are the only one that I need to be concerned with getting into my PowerBI?
I have spent sometime on it to date but can't seem to get it to pull in ONLY Column A, All Rows and Column C, All Rows - therefore, any kind guidance, signposting or assistance in getting this to a resolution whilst increasing my learning, would be very much appreciated.
Thanks in advance.