5 Click on Get under Files as shown in the figure 6 In the Get Data Files page

5 click on get under files as shown in the figure 6

This preview shows page 135 - 142 out of 146 pages.

5. Click on Get under Files as shown in the figure. 6. In the Get Data Files page click on OneDrive Business as shown in the figure.
Image of page 135
Version: 01.10.2017 Copyright 2015 Microsoft 136 | P a g e Maintained by: Microsoft Corporation 7. Select the VanArsdelExcelReport you uploaded to your Onedrive for Business and click Connect as shown in the figure. 8. In the OneDrive for Business page you have two options: a. Import Excel data into Power BI. b. Connect, Manage and View Excel reports in Power BI. 9. Select option (b) (Connect) as highlighted in the figure.
Image of page 136
Version: 01.10.2017 Copyright 2015 Microsoft 137 | P a g e Maintained by: Microsoft Corporation 10. Once the Excel workbook has been successfully connected to Power BI you will see the information shown in the figure on top right corner of your browser. 11. You will now see the Excel report under the Reports. You will notice an Excel icon next to the report to indicate it’s a high fidelity Excel report, meaning the excel content with pivot tables and charts can be viewed in Power BI.
Image of page 137
Version: 01.10.2017 Copyright 2015 Microsoft 138 | P a g e Maintained by: Microsoft Corporation 12. If you click the ellipsis (…) to the right of the report, you will have the option to View the report. 13. Clicking View opens the excel report within Power BI. Notice the Pivot Table reports is displayed. 14. Highlight the Excel cells with data and click on the Pin on the top right corner. 15. Pin the Excel report to .VanArsdel dashboard. Navigate to the other sheets of the excel work book and filter the pivot table to analyze data.
Image of page 138
Version: 01.10.2017 Copyright 2015 Microsoft 139 | P a g e Maintained by: Microsoft Corporation 16. Navigate back to .VanArsdel dashboard and notice the Excel report is part of the dashboard. 17. Resize and reposition the tiles as shown.
Image of page 139
Version: 01.10.2017 Copyright 2015 Microsoft 140 | P a g e Maintained by: Microsoft Corporation 18. To schedule a refresh for your Excel workbook click on the ellipses … next to your Excel report and click Schedule Refresh. 19. You will be in the Settings page. Depending on your source data (cloud or on premise) you can setup data refresh. If the source data is on premise you need a personal gateway. We will not be setting up data refresh again in this section. You can setup the data refresh very similar to what you did in earlier section for your Excel workbooks. You have learned how to view and manage your Excel reports within Power BI. You can now communicate to your power users of Excel to leverage this functionality for your workbooks. This helps address the fourth business problem we reviewed earlier.
Image of page 140
Version: 01.10.2017 Copyright 2015 Microsoft 141 | P a g e Maintained by: Microsoft Corporation Row-Level Security Row-level security with Power BI can be used to restrict data access for given users. Remember we have created various roles in the Power BI Desktop model. Using Power BI Service, we will add users to these roles. For dashboards with row-level security enabled, QnA and Quick Insights is not enabled. Since we are using both QnA and Quick Insights feature in the .VanArsdel dashboard we created, let’s create a new dashboard and publish a different Power BI Desktop file which has row-level security created.
Image of page 141
Image of page 142

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture