Cleaning up unstructured excel purchase orders and converting it to table format.

[govindhanp]

I am looking to import purchase order excel files from sharepoint and import it into the MS Power into table format.
Multiple excel files from sharepoint and table format in the power bi and need to save it to DB or need to take it as web api. 


and output I am excepting like below one 



for first image input - I am excepting output like this, for understaing, 

[v-pnaroju-msft · Accepted solution]

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:

1. Connect the SharePoint data source to Power BI and import the required data.
2. Once the data is available in Power BI, use the Power Query Editor to transform it into a structured table format.
3. After transforming the data, create a Power BI report to visualize the information using tables, charts, etc.
4. 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

[v-pnaroju-msft]

Hi govindhanp,

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.

Best Regards,

Pavan

[v-pnaroju-msft]

Hi govindhanp,

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.

If you found our response useful, kindly mark it as the accepted solution and provide kudos to guide other members.

Best regards,
Pavan

[v-pnaroju-msft]

Hi govindhanp,

We have not received a response from you regarding the query and were following up to check if you have found a resolution. If you have identified a solution, we kindly request you to share it with the community, as it may be helpful to others facing a similar issue.

If you find the response helpful, please mark it as the accepted solution and provide kudos, as this will help other members with similar queries.

Best regards,
Pavan

[Omid_Motamedise · Accepted solution]

This video can help you

https://www.youtube.com/watch?v=pofthD7-YuQ&pp=ygUicG93ZXIgcXVlcnkgbWVyZ2UgbXVsdGkgcm93IGhlYWRlcg%3D...

[v-pnaroju-msft · Accepted solution]

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:

1. Connect the SharePoint data source to Power BI and import the required data.
2. Once the data is available in Power BI, use the Power Query Editor to transform it into a structured table format.
3. After transforming the data, create a Power BI report to visualize the information using tables, charts, etc.
4. 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

[danextian]

Hi @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/144...