tracy's avatar
tracy
Frequent Visitor
9 years ago
Status:
Done

We couldn't import data from Excel Workbook

I'm facing an issue as per screen shot. I tried importing excel file from Power BI service. Get Data -> Files -> Local Files -> Import. Anyone had faced same issue? Can help to provide solution? Thanks

APIS and Embedding
Reports

5 Comments

  • v-haibl-msft's avatar
    v-haibl-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    tracy

     

    What is the content in your excel workbook? I can import a simple excel file which only includes a table in it successfully.

     

    Best Regards,

    Herbert

  • tracy's avatar
    tracy
    Frequent Visitor
    9 years ago

     

    Hi v-haibl-msft, I should've tabulated my data in excel file first. After I transformed the records into a table format, I was able to import it.

    But, after importing I noticed that you can't create measures or add columns at the Power BI online dataset. Sources are directing to use Power BI desktop. But, that way we won't be able to refresh records peridocally, am I correct?

    How do I schedule refresh if I'm going publish from Power BI desktop after customizing my dataset? I'm using Power BI Pro. 

     

     

  • v-haibl-msft's avatar
    v-haibl-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    tracy

     

    We can only create measures and columns in Power BI Desktop but cannot do it in Power BI Service.

    After you publish the report from Desktop to Service, you can schedule refresh with gateway. Please refer to this document.

     

    Best Regards,

    Herbert

Completed Ideas