Sự kiện
Giải vô địch thế giới Power BI DataViz
16 giờ 14 thg 2 - 16 giờ 31 thg 3
Với 4 cơ hội tham gia, bạn có thể giành được gói hội nghị và lọt vào Chung kết TRỰC TIẾP ở Las Vegas
Tìm hiểu thêmTrình duyệt này không còn được hỗ trợ nữa.
Hãy nâng cấp lên Microsoft Edge để tận dụng các tính năng mới nhất, bản cập nhật bảo mật và hỗ trợ kỹ thuật.
APPLIES TO:
Power BI Report Builder
Power BI Desktop
Paginated reports are designed to be printed or shared. They're called paginated because they're formatted to fit well on a page. They display all the data in a table, even if the table spans multiple pages. You can control their report page layout exactly. Power BI Report Builder is the standalone tool for authoring paginated reports for the Power BI service.
Here are some quick links if you're ready to get started:
Paginated reports often have many pages. For example, this report has 563 pages. Each page is laid out exactly, with one page per invoice, and repeating headers and footers.
You can preview your report in Report Builder, then publish it to the Power BI service, app.powerbi.com.
License requirements for Power BI paginated reports (.rdl files) are the same as for Power BI reports (.pbix files).
A major advantage of paginated reports is their ability to print all the data in a table, no matter how long. Picture that you place a table in a Power BI report. You see some of its rows in the table on the page, and you have a scroll bar to see the rest. If you print that page, or export it to PDF, the only rows that print are the ones you saw on the page.
Now say you place the same table in a paginated report. When you print it or export it to PDF, the paginated report has as many pages as necessary to print every row in that table.
You can view a demonstration of a similar table being printed in the two report formats in this video, which is Module 1, part of an eight-module video-based course, Power BI Paginated Reports in a Day. The course is designed to empower you as a report author with the technical knowledge required to create, publish, and distribute Power BI paginated reports.
Paginated reports have their own design tool, Power BI Report Builder. It's a new tool that shares the same foundation as the tools you'd previously used to create paginated reports for Power BI Report Server or SQL Server Reporting Services (SSRS). In fact, paginated reports that you create for SSRS 2016 and 2017 or for Power BI Report Server on-premises, are compatible with the Power BI service. The Power BI service maintains backwards compatibility so you can move your reports forward, and you can upgrade any previous-version paginated reports. Not all report features are available at launch. See Considerations and limitations in this article for details.
Sensitivity labels can be applied to paginated reports hosted in the Power BI service. After uploading a paginated report to the service, you apply the label to the report just as you would to a regular Power BI report.
Read more about sensitivity label support for pagination reports.
A single paginated report can have a number of different data sources. It doesn't have an underlying data model, unlike Power BI reports. You create embedded data sources and datasets in the paginated report itself. You can't use shared data sources or shared datasets. You create reports in Report Builder on your local computer. If a report connects to on-premises data, after you upload the report to the Power BI service, you need to create a gateway and redirect the data connection. Here are some of the data sources you can connect to:
See Supported data sources for Power BI paginated reports for a complete list.
Table reports work well for column-based data. Matrix reports, like cross-tab or PivotTable reports, are good for summarized data. Chart reports present data in a graphical format, and free-form list reports can present almost anything else, such as invoices.
You can start with one of the Report Builder wizards. The Table, Matrix, and Chart wizards walk you through creating the embedded data source connection and embedded dataset. Then you drag and drop fields to create a dataset query, select a layout and style, and customize your report.
With the Map wizard, you create reports that display aggregated data against a geographic or geometric background. Map data can be spatial data from a Transact-SQL query or an Environmental Systems Research Institute, Inc. (ESRI) shapefile. You can also add a Microsoft Bing map tile background.
Modify your data by filtering, grouping, and sorting data, or by adding formulas or expressions. Add charts, gauges, sparklines, and indicators to summarize data in a visual format. Use parameters and filters to filter data for customized views. Embed or reference images and other resources, including external content.
Everything in a paginated report, from the report itself to every text box, image, table, and chart, has an array of properties you can set to make the report look exactly as you want it.
When you design a paginated report, you're really creating a report definition. It doesn't contain the data. It specifies where to get the data, which data to get, and how to display the data. When you run the report, the report processor takes the report definition you've specified, retrieves the data, and combines it with the report layout to generate the report. You upload the report definition to the Power BI service, https://app.powerbi.com
, either to your My Workspace or to a workspace shared with your colleagues. If the report data source is on premises, after you upload the report, you redirect the data source connection to go through a gateway.
You view your paginated report in the Power BI service in a browser, and also in the Power BI mobile apps. From the Power BI service, you can export the report to a number of formats, such as HTML, MHTML, PDF, XML, CSV, TIFF, Word, and Excel. You can also share it with others.
You can set up email subscriptions for yourself and others for paginated reports in the Power BI service. In general, the process is the same as subscribing to reports and dashboards in the Power BI service. Paginated report subscriptions in the Power BI service are similar to email standard subscriptions in Power BI Report Server and SQL Server Reporting Services. In setting up subscriptions, you choose how often you want to receive the emails: daily, weekly, or hourly. The subscription contains a PDF attachment of the entire report output.
For details, see "Subscribe to paginated reports" in the article Email subscriptions for reports and dashboards in the Power BI service.
In the Power BI service, you can use the deployment pipeline tool with paginated reports. Deployment pipelines let you develop and test your Power BI paginated reports before you release them to your users. The tool is a pipeline with three stages:
Read about how to get started with deployment pipelines in the Power BI service.
With Power BI embedded analytics, you can create Power BI content that displays paginated reports in a fully integrated and interactive application. You can embed paginated reports either for your customers or for your organization. See Embed Power BI paginated reports for more information.
Here are some other features that aren't supported:
Sự kiện
Giải vô địch thế giới Power BI DataViz
16 giờ 14 thg 2 - 16 giờ 31 thg 3
Với 4 cơ hội tham gia, bạn có thể giành được gói hội nghị và lọt vào Chung kết TRỰC TIẾP ở Las Vegas
Tìm hiểu thêmĐào tạo
Mô-đun
Publish and access reports in Power BI service – Online workshop - Training
Learn how to use Power BI to create a mobile view, publish a report, build a dashboard, and use storytelling with Power BI within PowerPoint.
Chứng chỉ
Được Microsoft Chứng nhận: Liên kết Phân tích Dữ liệu Power BI - Certifications
Thể hiện các phương pháp và thực tiễn tốt nhất phù hợp với yêu cầu kỹ thuật và kinh doanh để lập mô hình, trực quan hóa và phân tích dữ liệu với Microsoft Power BI.
Tài liệu
Power BI Report Builder - Power BI
Power BI Report Builder is a tool for authoring paginated reports that you can publish to the Power BI service. Paginated reports are designed to be printed or shared. They're formatted to fit well on a page, and they display *all* the data in a table, even if the table spans multiple pages.
Tutorial: Create a paginated report and upload it to the Power BI service - Power BI
Learn how to connect to a sample Azure SQL database, use a wizard in Report Builder to create a paginated report, then upload it to any workspace in the Power BI service.
Create and use the paginated report visual - Power BI
In this article, you learn how to add the paginated report visual for Power BI reports.