< Home

Have you ever wanted to create paginated reports in Power BI, but felt intimidated by the coding involved? If so, you’re not alone. Many users find paginated reports challenging to create, especially if they don’t have a strong coding background.

But what if I told you that there’s a way to create paginated reports in Power BI without writing a single line of code? Sounds too good to be true, right? Well, it’s not. Thanks to the new low code authoring feature in Power BI, you can now create paginated reports using a visual interface that’s easy and intuitive. 😍

In this article, I’ll show you how to use low code authoring for paginated reports in Power BI in five simple steps:

  • Enabling Low Code Authoring
  • Designing Your Report
  • Adding Data
  • Formatting and Styling
  • Publishing and Sharing

Let’s dive in!

Step 1 – Enabling Low Code Authoring

To start using low code authoring for paginated reports in Power BI, you need to enable the feature in the Power BI service. Simply go to the Power BI portal and navigate to the settings. Under the ‘Admin portal’ section, click on ‘Paginated reports settings’. From there, you can enable low code authoring by toggling the switch to ‘On’. Once enabled, you’ll have access to the low code authoring capabilities for paginated reports. 🔥

Step 2 – Designing Your Report

With low code authoring, designing your paginated report is as easy as drag and drop. The visual interface allows you to add elements such as tables, charts, and images to your report by simply dragging them onto the canvas. You can then customise the appearance and layout of each element by adjusting the properties and settings. This intuitive design process makes it quick and effortless to create visually appealing reports. 🙌

Step 3 – Adding Data

To populate your paginated report with data, you’ll need to connect to the appropriate data sources. Power BI supports a wide range of data sources, including Excel files, SQL databases, and online services. Simply select the ‘Get Data’ option and choose the desired data source. Once connected, you can use the drag-and-drop interface to add data fields to your report and organise them as needed. 🚀

Step 4 – Formatting and Styling

Low code authoring offers extensive options for formatting and styling your paginated report. You can change the font styles, colors, and sizes to match your brand or personal preferences. Additionally, you can apply conditional formatting to highlight specific data points or create interactive elements such as drill-through actions. With these customisation capabilities, you can create reports that are not only informative but also visually engaging. 💯

Step 5 – Publishing and Sharing

Once you’ve designed and customised your paginated report, it’s time to publish and share it with others. With low code authoring, you can easily publish your report to the Power BI service and make it accessible to your intended audience. From there, you can share the report with specific users or groups, embed it in websites or apps, or even schedule it to be automatically refreshed with the latest data. The options for publishing and sharing are flexible and cater to various collaboration and distribution needs. 🙌

Conclusion – Empowering Users with Low Code Authoring

Low code authoring of paginated reports in Power BI is a game-changer for both experienced developers and non-technical users. It empowers users to create professional reports without the need for extensive coding knowledge, opening up new possibilities for data analysis and visualisation. By enabling low code authoring and leveraging its intuitive features, you can unlock the power of paginated reports and take your reporting capabilities to the next level. 🚀

If you need any help or guidance on how to use low code authoring or any other Power BI feature, don’t hesitate to contact us at Hopton Analytics. We are experts in data, Business Intelligence (BI), and Microsoft Power Platform. We can help you collect, transform, and visualise your data using Power BI, a powerful tool that lets you create stunning reports and dashboards. 💯

Whether you need a fully managed BI-as-a-Service solution or just some advice on how to get started with Power BI or low code authoring, we are here to help. 😊