We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
My client is moving a SharePoint 2013 farm to SharePoint 2016 in Azure. This will result in the loss of Excel Services since Office Online Server is not permitted in Azure. I think that Power BI Report Server would be a good replacement, but I'm not sure how we would move their existing Excel files into Power BI Report Server. Can anyone provide any guidance?
To connect your Excel file via Sharepoint, follow these steps. If you haven't already, you'll need to generate a direct download link in Excel. Open the file you want to share, then select Share. In the Send Link window that appears, make sure access is set to Anyone with the link can edit.
Follow these steps to save an Excel 2010 spreadsheet or workbook to a SharePoint library:
Click the File tab.
Click Save & Send, and then click Save to SharePoint.
Find the SharePoint location to which you want to save, and click Save As.
In the Save As dialog box, click Save.
Power BI Report Server doesn't support web-based viewing of Excel workbooks via Office Online Server (at least not yet).
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 1 |