Forum Discussion

risDS's avatar
risDS
Frequent Visitor
4 years ago
Solved

Unable to upload Excel data via API

Hello everybody, I am trying to programatically upload an Excel file (could also be a JSON file) to a workspace using the API but I can't seem to make it quite work. I am using the endpoint as spec...
Need Help
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    3 years ago

    Hi risDS  ,

     

    Quick solution

    1. Edit your workbook in Excel.
    2. Select the range of cells that contain your data. The first row should contain your column headers (the column names).
    3. Press Ctrl + T to create a table.
    4. Save your workbook.
    5. Return to Power BI and import your workbook again

     

     

    You need create a data model in your excel when you want to upload excel to power bi serive.

     

    For more details, you can refer this link.

    Error: We couldn't find any data in your Excel workbook - Power BI | Microsoft Docs

     

    Best Regards

    Community Support Team _ chenwu zhu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-chenwuz-msft's avatar
v-chenwuz-msft
Community Support
3 years ago

Hi risDS  ,

 

Quick solution

  1. Edit your workbook in Excel.
  2. Select the range of cells that contain your data. The first row should contain your column headers (the column names).
  3. Press Ctrl + T to create a table.
  4. Save your workbook.
  5. Return to Power BI and import your workbook again

 

 

You need create a data model in your excel when you want to upload excel to power bi serive.

 

For more details, you can refer this link.

Error: We couldn't find any data in your Excel workbook - Power BI | Microsoft Docs

 

Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.