Forum Discussion
Solved
[Help Requested] PowerQuery Formatting into Either JSON or CSV file
Hi all, I have this string of data from that I want to convert to either a CSV or JSON and eventually upload to SQL for further editing. Link: https://gist.github.com/Granitosaurus/0a9555c43...
Hi aalbano,
Hope you are doing well.Firstly ensure the file is valid JSON before renaming. If not, structure it correctly and use the JSON connector.
For raw or semi-structured data, use Power Query to clean and split it into rows/columns before converting to CSV.To cleanse data in Power Query:
- Open Power BI, go to Get Data, select Text/CSV, and load the file or paste the data. Power Query will treat it as a single column initially.
- In Power Query, select the column, go to the Transform tab, and choose Split Column by Delimiter.
- After splitting, go to Transform, Trim to remove spaces and rename columns if needed. Then save the cleaned and structured data as a CSV file.
By following the above steps you might achieve the desired output.
Please mark the helpful reply as the solution to assist others with similar queries. If you encounter further issues, don’t hesitate to reach out!
Thankyou for reaching out to the Microsoft Fabric Community Forum!
