0 Kudos

We couldn't import data from Excel Workbook

Status: Delivered
by tracy Frequent Visitor on ‎11-25-2016 01:45 AM

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

ExcelIssue.jpg

Status: Delivered
Comments
by v-haibl-msft Super Contributor
on ‎11-27-2016 09:58 PM

@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

by Vicky_Song Established Member
on ‎11-28-2016 09:44 PM
Status changed to: Needs Info
 
by Vicky_Song Established Member
on ‎11-28-2016 09:44 PM
Status changed to: Delivered
 
by tracy Frequent Visitor
on ‎11-28-2016 10:52 PM

 

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. 

 

 

by v-haibl-msft Super Contributor
on ‎11-29-2016 09:28 PM

@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

Idea Statuses