Power BI Report Builder reports with SQL Server on-prem

Hi, tbakrf 

No additional data connectors or helpers are required.

Prerequisites for using paginated reports:

• You don't need any license to download Power BI Report Builder from the Microsoft Download Center for free.
• You can publish and share paginated reports in your My Workspace or in other workspaces, as long as the workspace is in a Power BI Premium capacity and you have write access to the workspace.
• In a Premium Gen1 capacity, a Power BI admin needs to enable paginated reports in the Premium capacities section of the Power BI admin portal. In a Premium Gen2 capacity, paginated reports are enabled automatically.

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:

• Azure SQL Database and Azure Synapse Analytics (via Basic and oAuth)
• Azure Analysis Services (via SSO)
• SQL Server via a gateway
• Power BI datasets
• Oracle
• Teradata

For reference:

https://docs.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-report-builder-power-bi 

https://docs.microsoft.com/en-us/learn/modules/create-paginated-reports-power-bi/ 

https://docs.microsoft.com/en-us/power-bi/enterprise/service-premium-per-user-faq 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.