Forum Discussion
Cleaning up unstructured excel purchase orders and converting it to table format.
Hi govindhanp,
We appreciate your inquiry through the Microsoft Fabric Community Forum.
Based on your query, please follow the high-level steps provided below to resolve the issue:
- Connect the SharePoint data source to Power BI and import the required data.
- Once the data is available in Power BI, use the Power Query Editor to transform it into a structured table format.
- After transforming the data, create a Power BI report to visualize the information using tables, charts, etc.
- Publish the report to the Power BI Service. Create a dataflow in the Power BI Service to save the transformed data to a database (e.g., Azure SQL Database). Set up a scheduled refresh to ensure the data remains updated.
If you find this response helpful, kindly mark it as the accepted solution and provide kudos. This will assist other members with similar queries.
Best Regards,
Pavan
Super UserHi govindhanp
This is possible but certainly a lot of work. Also your expected result should match with your sample data. Where did you job and customer ids come from? Most of the column headers in your result do not match what's in your sample. Please refer to this post: https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/td-p/1447523/jump-to/first-unread-message