Forum Discussion
Creating a unstructured table
Hi guys, New to PBI, and in need of some assitance (assuming it's possible). I need to create an upload file with a fixed format via PowerBI. The unstructured format is below: 3 tags,...
Not sure I understand the format. Are there commas separating the columns and values? It simply a CSV file? Can you post a picture of the file contents from Notepad? Feel free to obfuscate sensitive data as needed.
it was a excel file. It looks like this. Should of included it apologies.
Ah, we can work with this in Power Query.
Load it using an Excel connector, but delete any and all Applied Steps other than Source and Navigation, stuff like Changed Type and especially Promoted Headers. (Is the data maybe CSV? It will still work.)
Now apply steps in order:
- Remove top rows, number to remove: 1
- Promote Headers
- Filter column <ID> to remove values of <Data> and <EOT>
- Change the Data Type of <ID> column to INT.
- Rename column headers for readability if you want.
