Forum Discussion

govindhanp's avatar
govindhanp
Regular Visitor
1 year ago
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...
General Comment
Need Help
Tips and Tricks
  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    1 year ago

    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's avatar
v-pnaroju-msft
Icon for Community Support rankCommunity Support
1 year ago

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