cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AlejandroG Regular Visitor
Regular Visitor

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

Accepted Solutions
zoloturu
Advisor

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

Hi @AlejandroG,

 

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!

 

 

4 REPLIES 4
zoloturu
Advisor

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

Hi @AlejandroG,

 

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!

 

 

AlejandroG Regular Visitor
Regular Visitor

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

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.

zoloturu
Advisor

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

Hi @AlejandroG,

 

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!

Highlighted
AlejandroG Regular Visitor
Regular Visitor

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

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? Smiley Happy

 

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.