This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
I am planning to work on PowerBI Project. I have a client requirement to depoy PowerBI reports on premise SQL Server Report Server.
I know that we can get the PowerBI Report Server Licence by using one of the following ways
It would be very helpful for me if any one can suggest / provide the solution on my below queries
Query1
In SQL Server Report Server, we can import 2 GB of data. Is there any way to import more than 2 GB data in SQL Server Report Server? I have approx 8 to 10 GB data to import.
Query2
Can we get the same P SKUs licence for PowerBI Report Server using SQL Server Enterprise Edition with Software Assurance (SA) as we can get Power BI Premium to deploy reports on PowerBI Service?
e.g can get P1 (8 Core) or P2 (16 Core) or P3 (32 Core)...licence for PowerBI Report Server
If yes then what would be import limit in PowerBI Report Server for P1, P2, P3....
Many Thanks in Advance.. Really great if any one can resolve these queries
Hi @Anonymous ,
1) You can use SSAS If you need more space for your data (that's very common)
2) I don't think you can publish to the Service If you have no Pro Licence - you need this one to deploy reports in both versions-> Cloud/ OnPremises. The Premium Capacity is only to have more capacity in the Power BI Service and to use some fancy features :).
Best,
Kathrin
If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |
| User | Count |
|---|---|
| 3 | |
| 3 | |
| 3 | |
| 2 | |
| 2 |