在SharePoint 平台上发布一个Power BI 报表
来源:互联网 发布:cad找不到网络打印机 编辑:程序博客网 时间:2024/04/28 01:54
使用SharePoint 列表数据创建一个桌面版的Power BI 报表
1. Let's use the same data Finance Sample Workbook from Power BI site for this example as well2. Load the data in SharePoint List
3. Open the Power BI for desktop tool and sign in using your O365 ID & password
4. Click File -> New -> It should open the blank report
5. Click Get Data option from Home menu -> More -> Online Services -> SharePoint Online List as shown below:
6. Enter the SharePoint URL - just the site collection but not till the List URL
7. Once you enter, select Microsoft account option from Anonymous, Windows, Microsoft account options displayed for authentication as shown below:
9. An important point to note is that the Finance Sample Excel Workbook is loaded into SharePoint List and now the data is connected to Power BI. If you notice the loaded data (columns Gross Sales, Sales Price, COGS, Profit related to cost) in Power BI are loaded as text instead of $$$ value in this example
10. Using Power BI, we can change the data type (NOTE: changing the data type will affect the data refresh so it is a good practice to change the data type in the source or load the data at the source with an appropriate data type). For this example, data type has been changed in the Power BI for the desktop.
Option is Data section -> Modeling tab in Ribbon -> Data Type & Format as shown below:
11. Loaded data and updated with data type is shown below:
12. In the above data loaded columns month, year are in a separate column, let's use DAX expression to combine them and display as Year - Month in a separate column. A new column "Date" is added as shown below:
13. Once the data is loaded, fields section shows the column that can be added to report, also the fields which can be displayed as aggregate/sum and also the measure created (Date field in above step):
14. Now, it's time to add the charts in the report section. Used Card, KPI, Line & Clustered Column Chart, Pie Chart, Line Chart to complete the report which is shown below:
Publish the report to SharePoint Online (Power BI Pro)
15. Now, it's time to publish the report to SharePoint Online. First step is to publish the report to work space in Power BI site then to SP Online.
Log in to the Power BI site. In the above step, above report has been published to "My Workspace" section. Hence navigate to the My Workspace section in Power BI site -> Reports section (since this is published as report but not dashboard) -> click on the report ("Sales Report")
Now, click on the File -> click on select Embed in SharePoint Online preview as shown below. This will give the link to publish the Power BI report to SharePoint Online.
16. Now, time to integrate the report in SharePoint Online. In the previous article, have explained about creating Communication Sites in SharePoint Online. Now, create a page and then add Power BI (preview) web part as shown below:
17. Now, name the page and publish the page. Below is the preview of the page and how the filter works in the chart according to the selection:
18. Next one final step is "Data Refresh". Navigate to the Power BI site again -> Work spaces -> My work space -> Data sets -> select your report (Sales Report) -> Schedule Refresh button in Actions section to schedule the data refresh as shown below:
Log in to the Power BI site. In the above step, above report has been published to "My Workspace" section. Hence navigate to the My Workspace section in Power BI site -> Reports section (since this is published as report but not dashboard) -> click on the report ("Sales Report")
Note: Embed in SharePoint Online is only available with Power BI Pro. Each user that views the report mush have a Power BI Pro license. If they do not have a Pro license, they will be prompted to sign-up to view the report
iOS Power BI App preview of the report
Granting Access to reports
Embedding a report in SharePoint Online does not automatically give users permission to view the report in SharePoint site. The permissions to view the report are set within Power BI service itself.
1. There are two ways to provide access to the report within the Power BI service. If you are using Office 365 Group to build your SharePoint Online team site, you list the user as a member of the app work space within the Power BI service. This will make sure that users can view the contents of that group. For more information , see Create and distribute an app in Power BI.
2. Alternatively, you can grant users access to your report by doing the following.
a. Add a tile from the report to a dashboard.
b. Share the dashboard with the users that need access to the report. For more information, see Share a dashboard with colleagues and others .
Reference: https://powerbi.microsoft.com/en-us/documentation/powerbi-service-embed-report-spo/
1. There are two ways to provide access to the report within the Power BI service. If you are using Office 365 Group to build your SharePoint Online team site, you list the user as a member of the app work space within the Power BI service. This will make sure that users can view the contents of that group. For more information , see Create and distribute an app in Power BI.
2. Alternatively, you can grant users access to your report by doing the following.
a. Add a tile from the report to a dashboard.
b. Share the dashboard with the users that need access to the report. For more information, see Share a dashboard with colleagues and others .
Reference: https://powerbi.microsoft.com/en-us/documentation/powerbi-service-embed-report-spo/
Publish the report to SharePoint (without Power BI Pro option)
Suppose you don't have Power BI pro license but want to integrate the Power BI report in SharePoint 2013 or 2016 or in SharePoint Online, then Page Viewer is the option we have :)Navigate to the page where you want to display the Power BI report -> add a Page Viewer Web Part -> add the link copied from Power BI site (Report -> File -> Embed in SharePoint Online(Preview)-> copy the link)
Differences between publishing using Power BI pro & in Page Viewer web part
1. Show/Hide Navigation Page, Filter Pane options are available only in Power BI6. Share the report via Facebook, Twitter, Linked In, Email, & information about report, flagging report option is available in normal publihing method (Page Viewe web part)
Export to PowerPoint (Preview)
There is another option available in reports in Power BI site which is Export to PowerPoint(Preview). Navigate to Power BI Site -> Select the report -> File -> Export to PowerPoint (Preview) as shown below:Downloads
- Power BI Desktop
- Power BI for Mobile - Windows, App Store, Google Play
- Power BI report file
- Sales report exported to PowerPoint
Conclusion
So, we have learned how to create a Power BI report from SharePoint List as data source, created DAX expressions, added different chart types, published the report to Power BI and then to SharePoint Online, SharePoint Online with out Power BI Pro and also applicable to SharePoint 2013 & 2016.
阅读全文
0 0
- 在SharePoint 平台上发布一个Power BI 报表
- SharePoint 2013 BI--Power Query for SharePoint
- 微软技术暨生态大会--SharePoint上搭建PBI【MVP】Power BI 结合 SharePoint 最佳案例(一,会议介绍)
- 如何在现有 SharePoint 服务器上安装 Power Pivot for SharePoint
- Part 1: 如何把Power BI 嵌入到sharepoint 网站
- 在SharePoint Server 2010上搭建Report的发布环境
- 在SharePoint Server 2010上创建和发布Report
- SharePoint BI
- [转贴]使用 Excel Services ,结合 Analysis Services 在 SharePoint 中发布报表
- ReportingServices无法在SharePoint集成模式下发布报表:http 400错误
- 使用 Excel Services ,结合 Analysis Services 在 SharePoint 中发布报表(转)
- Power-BI For K3免费版V10.0全新发布
- 奥威Power-BI连锁商超BI报表分析——“品牌销售分析”
- BI报表系统在银行业的应用
- 报表或BI的价值在哪?
- 在sharepoint 2010上如何创建一个调查
- 在一个Hybrid Cloud上部署测试的SharePoint farm
- 在tomcat上发布一个javaweb项目
- 三星电子2017年研发投入位列全球第四 华为第六
- MVP+注解+id+传值
- 网易有道云笔记去掉广告的最新方法
- 驱动调用底层的硬件
- 中国无人驾驶巴士亮相 汽车自动化时代即将来临
- 在SharePoint 平台上发布一个Power BI 报表
- Gartner:2018年智能市场成败见分晓 中国优势大
- 外国用华为设备安全吗 华为:零件70%来自全球
- R-FCN-3000算法笔记
- 最新趋势报告:使用智能机器人公司或被用户抛弃
- 公司业务宾馆开房均被直播 360:是否开启取决于商家
- Java基础 jsp介绍和jsp指令
- 初识WindowManager
- 预计中国网络安全产业规模将突破450亿元