Power BI Practice: Why 'Connect' Isn't Enough: Properly Recreate Power View Sheets in Power BI

Scenario:

You have a Microsoft Excel workbook that is saved to Microsoft SharePoint Online. The workbook contains several Power View sheets. You need to recreate the Power View sheets as reports in the Power Bl service.

Solution: From the Power Bl service, get the data from SharePoint Online, and then click Connect Does this meet the goal?

No, this solution does not fully meet the goal. While you can connect to the data from SharePoint Online in the Power BI service, this step alone will not recreate the Power View sheets as reports in Power BI.

Step-by-step guide

To achieve your goal, you need to follow these additional steps:

[1] Import the Data: Connect to the Excel workbook stored in SharePoint Online and import the data into Power BI.

[2] Recreate Visualizations: Manually recreate the visualizations from the Power View sheets using Power BI's visualization tools.

[3] Publish the Report: Once the visualizations are recreated, publish the report to the Power BI service.