Forum Discussion

burgesst's avatar
burgesst
Frequent Visitor
9 years ago

Export from Excel 2016 missing upload and export options, only dataset created

In Excel 2016, there is a 'Publish to Power BI' option.  It says you need to first save it to OneDrive for Business, and then you will be given the option to 'upload' or 'export'.   Well, I've save...
Need Help
burgesst's avatar
burgesst
Frequent Visitor
9 years ago

Hi, thanks for replying.  I have followed your instructions, but nothing really changed.

 

I still only get 'publish' not 'upload' or 'export'.  Interestingly, the icon is the same as the 'upload' on on yours.

 

Interestingly, if I have an Excel sheet with a PowePivot and a Powerview, the 'publish' option does work, but the PowerPivot comes through blank, and only the Powerview is there.  And it does refresh via the personal gateway.

 

If I use your 'get data' method, I get both the PowerPivot and the Powerview, but it is just a view of the Excel sheet and does not refresh unless the sheet is re-saved.  Is that right ?

 

Thanks!

 

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi burgesst,

I am not able to reproduce your issue using Excel. I would recommend you use the "Get Data > File > OneDrive for Business >Connect, Manage and View Excel in Power BI "option  instead, which is pretty same as the upload option in Excel 2016.

When you make changes to Excel, once you save, those changes will be updated in Power BI too, usually within about an hour. For more details about refreshing a dataset created from an Excel workbook on OneDrive, please review this article:https://powerbi.microsoft.com/en-us/documentation/powerbi-refresh-excel-file-onedrive/.


Thanks,
Lydia Zhang