Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Is all this correct?
Regards,
Alejandro.
Solved! Go to Solution.
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!
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!
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!
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
3 | |
1 | |
1 | |
1 |
User | Count |
---|---|
26 | |
3 | |
2 | |
2 | |
2 |