Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Can you "publish" paginated reports to PBI embedded without Premium or Report Server?

Hello! I´m trying to understand paginated reports. Please, correct me if I´m wrong.

 

So, as far as I know, you can download and build a paginated report using the report builder for free. 

 

After that you have two options:

  1.  You can publish the paginated report to PBI Report Server, which is like the online service (app.powerbi.com) but local. For this you need either a PBI Premium license (P SKU) or a SQL Server Enterprise license (both several thousands USD per month).
  2.  Now you also have the preview option to publish them directly to the service if, again, you have a premium license.
  3.  In the future you'll have another option: publishing paginated reports using a PBI embedded license.

 

Is all this correct? 

 

Regards, 

Alejandro.

1 ACCEPTED SOLUTION
zoloturu
Memorable Member
Memorable Member

Hi @Anonymous,

 

You can create a paginated report using SQL Server Reporting Services, which you can download for free and install for free if you will select Developer license type - https://www.microsoft.com/en-us/download/details.aspx?id=55252

 

1. It is correct.

2. Also right.

3. It already works:

 

Step1. Go to Azure portal https://portal.azure.com

Step2. Create Power BI Embedded instance with pricing tier not less than A4 (6 kUSD/month, around 8 USD/hour)

Step3. Run it (through a portal or via API)

Step4. Publish report to Power BI Service.

Step5. Enter credentials to the dataset.

Step6. Pause it once not needed (through a portal or via API)

 

As you can see you can try and use this feature for $8/hour. What I did as well.

 

Regards,
Ruslan
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!

 

 

View solution in original post

4 REPLIES 4
zoloturu
Memorable Member
Memorable Member

Hi @Anonymous,

 

You can create a paginated report using SQL Server Reporting Services, which you can download for free and install for free if you will select Developer license type - https://www.microsoft.com/en-us/download/details.aspx?id=55252

 

1. It is correct.

2. Also right.

3. It already works:

 

Step1. Go to Azure portal https://portal.azure.com

Step2. Create Power BI Embedded instance with pricing tier not less than A4 (6 kUSD/month, around 8 USD/hour)

Step3. Run it (through a portal or via API)

Step4. Publish report to Power BI Service.

Step5. Enter credentials to the dataset.

Step6. Pause it once not needed (through a portal or via API)

 

As you can see you can try and use this feature for $8/hour. What I did as well.

 

Regards,
Ruslan
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!

 

 

Anonymous
Not applicable

Hi @zoloturu, thank you for your answer. Some questions:

 

1. When you say "Step3. Run it (through a portal or via API)" do you mean using the PBI Report Server? "portal" = PBI Report Server and API = ?? (I´ve never used embedded before).

2. So you can use the PBI Report Server with an embedded license, correct?

3. Do you know if it´s possible to schedule and send paginated reports as PDFs via email from the PBI Report Server right now?

 

Best regards,

Alejandro.

Hi @Anonymous,

 

1. portal = https://portal.azure.com. It is a place where you create a Power BI Embedded instance

 

details on how to do that - https://docs.microsoft.com/en-us/power-bi/developer/azure-pbie-create-capacity

 

2. No. You can you Report Server if you have:

* Power BI Premium (P1 and more)

* SQL Server specific license (don't remember which one)

* or if you will select Developer license type during installation (it will give you 180 days free trial)

 

3. I don't think it is possible to do. Chris Webb has a good post about API inside of Report Server - https://blog.crossjoin.co.uk/2017/10/15/exploring-the-new-ssrs-2017-api-in-power-bi/. Maybe you will find some other options for you.

 

Regards,
Ruslan
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!

Anonymous
Not applicable

Ok so no Report Server with Embedded license (Azure SKU), so you can´t access the server from the browser but you can publish paginated reports to the service and you can also embed them in your application, so the functionality is very similar, don´t you think? 🙂

 

Can users with free PBI account access these reports in the service (published in a workspace with an assignated capacity from the Embedded license)? I am guessing they can obviously access them if the report is embedded in an application.

 

Thanks a lot for your help @zoloturu.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.