We are a very small ISV with 2 co-founders. We have a BizSpark subscription and are currently using Azure for our infrastructure. We use a SQL Azure database.
I have created several reports to share with my co-founder and we each have a Pro license ($20 per month in total). I want to give the users of our application the ability to view some of these reports using RLS.
I've followed the "App owns data" tutorials and can now see the reports with no issues (great!).
My co-founder informed me about new pricing for this. Last time I looked, Power BI Embedded charged by the session which was ideal. We have 15 customers and they will probably check these reports no more than twice a week.
To my horror, I checked the Azure pricing for Power BI Embedded and it is now telling me that my minimum price will be $750 per month. WTF?
Am I confusing services here? We aren't interested in dedicated capacity, and I've already linked our website to an embedded report without creating a Power BI Embedded service in Azure.
I would really appreciate anyone here clarifying where we stand. As a startup generating about $150 per month in revenue it makes absolutely no sense at all to use Power BI if these prices are what we'll now have to pay.
We walked away from Microstrategy as it was "WAY, WAY more" to get any kind of horsepower and even with their own cubing mechanism which takes forever to build a cube. My experience was it was built from the ground up, but slow to evolve (very slow) and a lot of the good people we worked with there jumped ship. They were heading in a terrible direction. I would consider Tableau or Qlik before the others...but Tableau will be as much or more than Power BI.
I haven't seen pricing lately with Qlik, but I bet it's close to the same.
If you are embedding only in another application, you can use an A SKU, but anyone internal using it, needs a pro license. We are using this model for our customers and we are a fortune 200 company last time I checked. P SKU is 5K a month.
I would say in the ISV model your option is A sku for ~$750 a month that gives you 3 GB RAM is all. We had to go to A3 to get any kind of performance $3K/mo, not to mention if you use cubes, and use AAS, we had to rack that up to an S3 otherwise we ran out of memory processing cubes. And the cubes are not big. GB's, but less than 10. You can pause A SKU's and you can do this through Azure portal yourself anytime. P sku's you have to be a global admin to do it and it's a yearly committment which A SKU is pay as you go.
We ended up using Power BI internally (there are only 2 of us) and unfortunately our customers ended up suffering. We've just gone with very basic export to Excel for now until we can find something reasonable to offer.
With regards the SKU for $750, that's over $1k AUD per month. To put that into context, our business currently has a revenue of around $4k AUD per month. Spending 1/4 of our revenue on a reporting solution is totally incomprehensible from a business perspective.