Forum Discussion
Programatically start/stop Azure PowerBI capacity for PowerBI Embedded
Hi all.
Here is the documentation:
https://docs.microsoft.com/en-us/rest/api/power-bi-embedded/capacities
Here is guide for setting up Postman:
https://www.codit.eu/blog/2017/03/14/authenticate-postman-against-azure-service-management-api/
Wish you well!
Goddamn hate Azure by now though.... hope that changesI found the REST api documented here. It seems to be working fine.
ckelbley wrote:
I have had success using these API calls:
POST https://management.azure.com/subscriptions/SUBSCRIPTION_ID/resourceGroups/RESOURCE_GROUP_NAME/providers/Microsoft.PowerBIDedicated/capacities/CAPACITY_NAME/resume?api-version=2017-10-01POST https://management.azure.com/subscriptions/SUBSCRIPTION_ID/resourceGroups/RESOURCE_GROUP_NAME/providers/Microsoft.PowerBIDedicated/capacities/CAPACITY_NAME/suspend?api-version=2017-10-01
Could you share where you find those APIs, any documentations?
I couldn't find any official documentation. I just did some trial and error using Postman and tried different calls based on how the management APIs work for other resource types and looking at what the browser does when you click the pause/start button in the Azure portal.
Hi all.
Here is the documentation:
https://docs.microsoft.com/en-us/rest/api/power-bi-embedded/capacities
Here is guide for setting up Postman:
https://www.codit.eu/blog/2017/03/14/authenticate-postman-against-azure-service-management-api/
Wish you well!
Goddamn hate Azure by now though.... hope that changesAwesome. Looks like that was published awhile ago, so don't know why I could not find it. Thanks for the help.
While we're relatively new to PowerBI, I sure find that the pieces do not hang together very well. From an embedded standpoint, the pricing is just stupidly high for low volume scenarios. I have given up attempting to get one of my workspaces associated with a PowerBI instance. 3 people at MS failed to ever explain why, so we gave up.
Hi.
----Pricing suggestion----
Low volume scenarios with pausing the SKUs are cheap? 1$ /hour on a minute basis for A1 core.
Just create many resources for different tiers of users maybe?
* 1 tier A1 for everyday use like maybe marketing and purchasing.
* 1 tier A6 for accounting/strategy/logistics desicions to use at Quarterly critical business moments?
Start/Stop upon Report render in your app.
Depends if you have to start services for 500-100 users at different times and such though..
If you don't need the ability for Crossfiltering, data discovery, edit and save cababilities and seamless Excel 2016/PowerPoint 2016 compatability then yeah Power BI is not the only way: Mongo dB Node.js backend - Angular 5 Frontend - Some java graphs like: https://www.fusioncharts.com/dev/chart-guide/pie-and-doughnut-charts/creating-pie-and-doughnut-charts.html
-----My story-----
My struggles with Power BI embedded has also been beyond reasonable 2weeks now.
After 45 mails, 3 calls and 4 Microsoft support contacts I finally got a tech that knew a thing or two about Azure and Power BI Embedded.
Microsoft Sign in - auto created accounts based on outlook accounts, created personal accounts instead of work/edu, Workspace Collections was still visible and available in Azure with documentation being outdated and not showing the new steps to take.
I have incorrectly managed via backdoor Microsoft CLI commands from Powershell create all the old resources but at the end nothing worked since Workspace Collections and Workspaces had been removed and I just received errors.
The next steps to take are scary and I fear will be as troublesome: How does Power BI PRO integrate with the new Embedded SKU solution. Almost all videos "GuyInTheCube" and Microsoft Docs/videos showcase the pre 2017-07-01 ways of embedding Reports.
If I ever get through this hell.. I will defenitely post a complete video on Youtube named "Pitfalls of Azure and Power BI Embedded - a complete Step by Step guide"