Forum Discussion

aalbano's avatar
aalbano
New Member
1 year ago
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...
Need Help
Tutorial Requests
  • v-sgandrathi's avatar
    v-sgandrathi
    1 year ago

    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!

v-sgandrathi's avatar
v-sgandrathi
Icon for Community Support rankCommunity Support
1 year ago

Hello aalbano.

 

We wanted to check in regarding your query, as we have not heard back from you. If you have resolved the issue, sharing the solution with the community would be greatly appreciated and could help others encountering similar challenges.

Thankyou for connecting with Microsoft Community Forum.

v-sgandrathi's avatar
v-sgandrathi
Icon for Community Support rankCommunity Support
1 year ago

 Hi aalbano,

 

We are following up to see if your query has been resolved. Should you have identified a solution, we kindly request you to share it with the community to assist others facing similar issues.

If our response was helpful, please mark it as the accepted solution and provide kudos, as this helps the broader community.

 

Thanks for using Microsoft Fabric Community Forum.

 

 

  • v-sgandrathi's avatar
    v-sgandrathi
    Icon for Community Support rankCommunity Support
    1 year ago

    Hi  aalbano,

     

    We wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.

    If my answer resolved your query, please mark it as "Accept Answer" and select "Yes" if it was helpful.

    If you need any further assistance, feel free to reach out.

     

    Thank you for being a valued member of the Microsoft Fabric Community Forum!