Forum Discussion
Solved
Cleaning up unstructured excel purchase orders and converting it to table format.
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...
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
v-pnaroju-msft
Community Support
Community SupportHi 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