I really appreciated the original Power BI licensing as it was pretty simple. Either Free / Pro and/or Premium. BAM. That continues into Microsoft Fabric. There are more items now though. Appreciate your thoughts that you found this easy. 👊
clarity? still cloudy af (sorry, couldn't resist) loaded nyc taxi data & racked up ~$200 in charges just messing around in a couple of days....not makin that fun to kick the tires
Thanks a lot Adam for explaining this ..For a very small org like ours .. just to store and move it around between Azure and Onelake is going to cost a lot . it would be better if MS streamlines their billnig concept ..
Thank you for the intro to pricing! But.. I'm still confused.. SKUs..CPUs..(still not clear why i may need 2048 capacity units instead of 2 units, and how they influence performance of datalake and PBI reports). It will be great If you consider different use cases of using fabric (for small business, medium, large, etc) in your future videos
I think I know where you're coming from. I couldn't tell if it's just my familiarity with the old ui or maybe it is a better ui and I'm just not familiar.
The worst for me was splitting the central Power BI admin portal im the web to 4 places! Azure/Office 365/Azure portal or whatever its called now and the miniscule settings now available in PBI web and desktop... I especially hate the scattering into lffice 365
This is nothing short of another MS created pricing nightmare -- this Fabric is a high-priced firehose scheme is designed to rake in subscription usage-based revenue from the very large enterprise willing to spend millions for their pbi experience. I have a client with 100 potential premium users and estimate the cost to be $96k per year (when we know only 20% of the subscribers will take advantage of the premium functionality). The small to medium sized biz has no chance to continue using PBI in a useful way ---- nice job MS, ... I'm sending my clients to Tableau or keeping them in Excel.
I too this day even though i work in BI; claim that Fabric is nothing new! It's just a licence packaging because Azure as a MDW platform got too scattered trying to bolt on everything AWS could do. Oh and I hate Cosmos DB, why they inclide at all in their certification is beylnd my understanding 😂
Adam, thanks for mentioning GCC! The GCC community is often left out and has to take videos like a grain of salt, however, it's refreshing to have it mentioned here. Thanks!
So, does it mean that if I already have a Power BI Premium P1 license, I already have a F64 Fabric's license? In other words, can I already use Fabric's features with a Power BI Premium license?
Thanks for this ! Helped clearup a few things but it's still very confusing. Microsoft licensing is a hot mess. They really wen't with the "If you can't convince, confuse" mantra.
Rather than go serverless like other cloud provider. At this point I think I would rather go full databricks or just migrate to another cloud. A lot of things that fabrics brings to the table is sounds great but the pricing.... Synapse Spark / Databricks is pay per uptime and no reservation needed. If you don't execute anything you are paying nothing. But in Fabric, you need to commit to your capacity first! And hope you provisions enough capacity and hope other resources in Fabric didn't take all of those CUs away way too much.
Hi Adam, great video as always 👍 but what do mean by we are not being charged CPU cycles till 1st August? If I buy Fabric capacity I do pay for compute resource which includes CPU, don't I?
How do "Capacity Units" even work. I deployed F8 with a tiny amount of CU's and ran a query against the new york taxi dataset and it showed 70+ CU's in the metrics app. The query completed, but it was WAY over my capacity.
It's a compute meter. Think of it like CPU cycles. I'll mark down to try and explain that in more detail to help understand it. The preview workloads aren't counting towards CU usage until August 1st, so it's not going to throttle you for now.
@@GuyInACubeare we paying for the CU and the compute time though? That’s the perception I got, that I would need to pay a fixed cost for the compute but then pay a cycle cost? Is there a transaction cost for reading and writing to the storage? A cost for transfer sizes?
What I am confused about is the new project file type (.pbip for git integration). Will this replace the pbix or will it run along side and will it only be available for those with Fabric capacity? Thanks
Is it right assume that an organization with existing E5 licensing (everyone able to be assigned a Pro License) now would simply incur additional expense for Power BI usage because you must commit to a Fabric Capacity on top of individual licensing to run Power BI now? Or can an org simply disable Fabric at the tenant/capacity level and run as they did before with shared Power BI compute and Pro/PPU Licensing (no Premium Capacity)?
I am still yet to understand who benefits from Fabric other than Microsoft themselves as users are pushed further into only using Microsoft products Its like a vet clinic handing out free kittens
It can be. In general, I think it can sometimes be less complicated than other offerings. It's definitely evolved over time though. What do you find is the most complicated piece of this that's hard to understand?
Dataverse, Azure or Microsoft Fabric. Is it accurate to say that Dateverse on the power platform is the best for SME's? i.e a good way to organise data from multiple excel sheets?
Q: will premium capacity always have fabric capabilities? Meaning when Microsoft releases fabric as GA will that change what fabric feature premium capacity give your?
Question that probably can't be answered today: If I get a F16 SKU as an RI (i.e., annual instead of pay as you go), can I upgrade to F32 if I undersized by paying the difference?
Hi Adam, in you video you mention converting powerbi embedded to fabric capacity in azure. I cannot see anywhere on how you would do that. Can you give some pointers?
You're still going to need premium per user for those orgs that aren't using premium capacity due to the xmla endpoint for interacting with the analysis services dataset, as well as large model format and dataset partitioning.
@@GuyInACube ok that make sense for hybrid usage (Datamart +F). But in case of standalone Datamarts (with no F) is PPU enough to get a 365 licence type for Datamart at a constant price with a capacity included ?
So if i own a Power BI Pro subscription for the tenant plus i buy an Fabric SKU (F2-F32) i am good to go with all the stuff Fabric comprises? 🤔 Asking for a friend.. 🧀
So... when you say it's free for Fabric workloads, does that mean only the Datasets and Power BI reports hosted on Fabric workspaces will be charged? I am bit confused now..... Thanks a lot for the summary! It helped me out a lot...
that is EXACTLY what that means --- they have taken what was at one time a service you paid $20 pu/pm to use, and applied a subscription capacity-use pricing scheme on top of it -- AND, bc they love their small clients so much, you still pay the $20 pm. Thanks for shopping at MS, if you dont like it, tough!
Hey guys , very informative video as always thank you . Help me understand I already have couple of p3s in place so I don’t need fabric is my understanding but what about the one lake storage ? Do I need to pay for it or do I get something free storage for my existing p3 ?
Trying to understand the whole licensing, capacities, VCores, SKU's, Workspaces, PowerBI things like reserved capacity, shared capacity, Fabric capacity, PPU, Premium PowerBI Fabric Premium, organizational licences, personal licenses, Office 365 SKU or Azure SKU (= F SKUs) and other stuff...okay..hmmm interesting...
now you have to demonstrate the difference in performance between F2 and the others. so the impact on spark jobs, on PBI report connected to a lakehouse... lot of job for you ;-)
Has Something changed about the pro license usage on non-power bi fabric item creation? The official fabric licensing page shows for the creation of no-power bi fabric items you need pro even if it's backed by a capacity!
Hmm...so if I want to play the OneLake story and "see" a large enterprise Data Lake which is sitting in AWS S3, there will be additional storage cost for this data and hence double payment for both AWS and Azure will occur, right?
So, I've bought a fabric capacity (F2)(In Azure), and I have a Power BI Premium Per User license, I've enabled the preview for the tenant, and I've reviewed all the sub settings on the Admin Portal for Power BI and I still can't seem to see the persona switcher, am I missing something?
if I already have a Power BI Premium P1 license is it the same as the F64 Fabric's license or Do I need to upgrade my P1 license to the Fabric License?
If I'm on, say, an F32 SKU, and I (as a creator) have a Power BI Pro license, can I create embedded reports running it that capacity that can be consumed by users with a Power BI Pro license?
What happens if I reach the max of my F sku. Will it become slow, stop working? Will the price by fixed? I don't want somebody to mess up and tripple the monthly cost.
In typical fashion for the topics of cloud and azure, this video avoids speaking of the number of dollars when speaking of cost. Its merely the instance types that matters to bottomless pockets it seems. I guess "if you gotta ask then it's too expensive for you" is the saying.
How does connectivity work, if we are trying to move data from On-prem systems or external clouds… S2S VPNs or Express Routes still a thing with Synapse in Fabric? Or just the PBI gateway will suffice?
Right now with a premium capacity Microsoft is providing 100 TB storage. Any new in storage they will give for onelake? Also anything on how to track additional charges apart from capacity we are paying and for which onelake.
thats too easy, they should make costing more complicated.
Just what I was thinking! 🤣
I really appreciated the original Power BI licensing as it was pretty simple. Either Free / Pro and/or Premium. BAM. That continues into Microsoft Fabric. There are more items now though. Appreciate your thoughts that you found this easy. 👊
I'm going to need 2048 capacity units just to figure out how much this is really going to cost!
@@micahgoodreau 🤣
@@GuyInACube Pay as you go is NOT like Power Bi Premium licensing and it complete opposite of self-service empowerment of business users
Thanks, as always, Adam, for presenting info in clear concise manner.
clarity? still cloudy af (sorry, couldn't resist) loaded nyc taxi data & racked up ~$200 in charges just messing around in a couple of days....not makin that fun to kick the tires
Hi, if I work in an organization with premium per capacity. If I activate Fabric Trial, will I get separate Compute during trial period ?
Thanks a lot Adam for explaining this ..For a very small org like ours .. just to store and move it around between Azure and Onelake is going to cost a lot . it would be better if MS streamlines their billnig concept ..
Im still a bit confused, so if you get a fabric license below F64 can you still create and consume both fabric and power bi products?
If you get a fabric license below F64 you will have to combine it with power bi pro for users to build and consume reports.
Thank you for the intro to pricing!
But.. I'm still confused.. SKUs..CPUs..(still not clear why i may need 2048 capacity units instead of 2 units, and how they influence performance of datalake and PBI reports).
It will be great If you consider different use cases of using fabric (for small business, medium, large, etc) in your future videos
I agree!
Good idea
adam and patrick who is the UI designer who completely ruined Power BI service -_- Old UI was 100 times better
exactly
I think I know where you're coming from. I couldn't tell if it's just my familiarity with the old ui or maybe it is a better ui and I'm just not familiar.
The worst for me was splitting the central Power BI admin portal im the web to 4 places! Azure/Office 365/Azure portal or whatever its called now and the miniscule settings now available in PBI web and desktop...
I especially hate the scattering into lffice 365
Do you know if Fabric will have a Premium Per User option in the future?
it‘s mentioned in the video. Plus you can create Non-Power BI stuff with any license
This is nothing short of another MS created pricing nightmare -- this Fabric is a high-priced firehose scheme is designed to rake in subscription usage-based revenue from the very large enterprise willing to spend millions for their pbi experience. I have a client with 100 potential premium users and estimate the cost to be $96k per year (when we know only 20% of the subscribers will take advantage of the premium functionality). The small to medium sized biz has no chance to continue using PBI in a useful way ---- nice job MS, ... I'm sending my clients to Tableau or keeping them in Excel.
I too this day even though i work in BI; claim that Fabric is nothing new!
It's just a licence packaging because Azure as a MDW platform got too scattered trying to bolt on everything AWS could do.
Oh and I hate Cosmos DB, why they inclide at all in their certification is beylnd my understanding 😂
Adam, thanks for mentioning GCC! The GCC community is often left out and has to take videos like a grain of salt, however, it's refreshing to have it mentioned here. Thanks!
Is it / will it be possible to automatically pause and resume capacity? Maybe on a schedule or when reports are in use?
This would also be useful for people trying to play with Fabrics to understand its working and their free trial has run out
yes you can do that with the paygo option
Yes
We had to build a logic app to pause and resume. I'd be keen to know if this now available out the box
So, does it mean that if I already have a Power BI Premium P1 license, I already have a F64 Fabric's license? In other words, can I already use Fabric's features with a Power BI Premium license?
i got power bi premium capacity and have same concern
Yes, but now you have to pay for the capacity that you once didnt pay for --- Adam is sneaky, he works for MS, so dont believe his pricing vids.
Thanks for this ! Helped clearup a few things but it's still very confusing.
Microsoft licensing is a hot mess. They really wen't with the "If you can't convince, confuse" mantra.
So long story short, Fabric is a thing for large enterprises. I doubt small businesses will go for it at that pay-as-you-go cost model.
Why is Microsoft go out of their way to make licensing always complicated... which makes competitors eat Microsoft's lunch.
Rather than go serverless like other cloud provider. At this point I think I would rather go full databricks or just migrate to another cloud. A lot of things that fabrics brings to the table is sounds great but the pricing....
Synapse Spark / Databricks is pay per uptime and no reservation needed. If you don't execute anything you are paying nothing. But in Fabric, you need to commit to your capacity first! And hope you provisions enough capacity and hope other resources in Fabric didn't take all of those CUs away way too much.
Hi Adam, great video as always 👍 but what do mean by we are not being charged CPU cycles till 1st August? If I buy Fabric capacity I do pay for compute resource which includes CPU, don't I?
Sounds expensive
How do "Capacity Units" even work. I deployed F8 with a tiny amount of CU's and ran a query against the new york taxi dataset and it showed 70+ CU's in the metrics app. The query completed, but it was WAY over my capacity.
It's a compute meter. Think of it like CPU cycles. I'll mark down to try and explain that in more detail to help understand it. The preview workloads aren't counting towards CU usage until August 1st, so it's not going to throttle you for now.
@@GuyInACubeare we paying for the CU and the compute time though? That’s the perception I got, that I would need to pay a fixed cost for the compute but then pay a cycle cost? Is there a transaction cost for reading and writing to the storage? A cost for transfer sizes?
What I am confused about is the new project file type (.pbip for git integration). Will this replace the pbix or will it run along side and will it only be available for those with Fabric capacity? Thanks
This guy's video content and delivery are outstanding.
Can Fabric Capacity SKU2 be used to cost effectively embed a report to non-licensed external users?
Is it right assume that an organization with existing E5 licensing (everyone able to be assigned a Pro License) now would simply incur additional expense for Power BI usage because you must commit to a Fabric Capacity on top of individual licensing to run Power BI now? Or can an org simply disable Fabric at the tenant/capacity level and run as they did before with shared Power BI compute and Pro/PPU Licensing (no Premium Capacity)?
I am still yet to understand who benefits from Fabric other than Microsoft themselves as users are pushed further into only using Microsoft products
Its like a vet clinic handing out free kittens
Hi, My Power BI pro license is renamed as Fabric Pro license. Is that also same as that of Fabric capacities and Power Premium Capacities?
Thanks
Good luck to all the SAM and ITAM guys out there. Godspeed!
That was a lot of information indeed. Microsoft pricing is indeed very complicated
It can be. In general, I think it can sometimes be less complicated than other offerings. It's definitely evolved over time though.
What do you find is the most complicated piece of this that's hard to understand?
Dataverse, Azure or Microsoft Fabric. Is it accurate to say that Dateverse on the power platform is the best for SME's? i.e a good way to organise data from multiple excel sheets?
Q: will premium capacity always have fabric capabilities? Meaning when Microsoft releases fabric as GA will that change what fabric feature premium capacity give your?
Can you please do a video describing how on premesis gateways will work with Fabric? Thanks for the content so far.
Following
Question that probably can't be answered today: If I get a F16 SKU as an RI (i.e., annual instead of pay as you go), can I upgrade to F32 if I undersized by paying the difference?
Hi Adam, in you video you mention converting powerbi embedded to fabric capacity in azure. I cannot see anywhere on how you would do that. Can you give some pointers?
You're still going to need premium per user for those orgs that aren't using premium capacity due to the xmla endpoint for interacting with the analysis services dataset, as well as large model format and dataset partitioning.
Yup. Still valid use cases for Premium Per User.
Drinking Game - take a shot every time he says 'Capacity'
What about Datamart cost with standalone Datamart ? Within hybrid fabric+Datamart choice ?storage and entreprise license ?
Datamarts is included with your Capacity. So, it just results in Compute usage.
@@GuyInACube ok that make sense for hybrid usage (Datamart +F). But in case of standalone Datamarts (with no F) is PPU enough to get a 365 licence type for Datamart at a constant price with a capacity included ?
For anyone watching also trying to figure all this out, they extended the non-BI free use trial date to Oct 1
So if i own a Power BI Pro subscription for the tenant plus i buy an Fabric SKU (F2-F32) i am good to go with all the stuff Fabric comprises? 🤔
Asking for a friend.. 🧀
Yup. Good to go. Every user will need Pro in that scenario for Power BI content
Nonprofit licensing?
Only 10:20 to explain pricing. Not complicated at all.
Do we have an eta on the shortcuts for Dataverse? Will there be shortcuts for Business Central as well?
So... when you say it's free for Fabric workloads, does that mean only the Datasets and Power BI reports hosted on Fabric workspaces will be charged? I am bit confused now.....
Thanks a lot for the summary! It helped me out a lot...
that is EXACTLY what that means --- they have taken what was at one time a service you paid $20 pu/pm to use, and applied a subscription capacity-use pricing scheme on top of it -- AND, bc they love their small clients so much, you still pay the $20 pm. Thanks for shopping at MS, if you dont like it, tough!
Hey guys , very informative video as always thank you . Help me understand I already have couple of p3s in place so I don’t need fabric is my understanding but what about the one lake storage ? Do I need to pay for it or do I get something free storage for my existing p3 ?
You will use Fabric, and you will not complain about it!
Trying to understand the whole licensing, capacities, VCores, SKU's, Workspaces, PowerBI things like reserved capacity, shared capacity, Fabric capacity, PPU, Premium PowerBI Fabric Premium, organizational licences, personal licenses, Office 365 SKU or Azure SKU (= F SKUs) and other stuff...okay..hmmm interesting...
now you have to demonstrate the difference in performance between F2 and the others.
so the impact on spark jobs, on PBI report connected to a lakehouse...
lot of job for you ;-)
Has Something changed about the pro license usage on non-power bi fabric item creation? The official fabric licensing page shows for the creation of no-power bi fabric items you need pro even if it's backed by a capacity!
Hmm...so if I want to play the OneLake story and "see" a large enterprise Data Lake which is sitting in AWS S3, there will be additional storage cost for this data and hence double payment for both AWS and Azure will occur, right?
Microsoft is so greedy
So, I've bought a fabric capacity (F2)(In Azure), and I have a Power BI Premium Per User license, I've enabled the preview for the tenant, and I've reviewed all the sub settings on the Admin Portal for Power BI and I still can't seem to see the persona switcher, am I missing something?
if I already have a Power BI Premium P1 license is it the same as the F64 Fabric's license or Do I need to upgrade my P1 license to the Fabric License?
Will embedding work with F2 to F32 SKU? If no, then small orgs will pay more if Microsoft is planning to deprecate A SKUs.
If I'm on, say, an F32 SKU, and I (as a creator) have a Power BI Pro license, can I create embedded reports running it that capacity that can be consumed by users with a Power BI Pro license?
What happens if I reach the max of my F sku. Will it become slow, stop working? Will the price by fixed? I don't want somebody to mess up and tripple the monthly cost.
Thank you Adam. Great summary I'm sending to my team.
When i have PowerBI premium capacity it means that i only have to switch button to use MS Fabric ?
When will power bi embedded (app owns data) support Direct Lake mode?
In typical fashion for the topics of cloud and azure, this video avoids speaking of the number of dollars when speaking of cost. Its merely the instance types that matters to bottomless pockets it seems. I guess "if you gotta ask then it's too expensive for you" is the saying.
How does connectivity work, if we are trying to move data from On-prem systems or external clouds… S2S VPNs or Express Routes still a thing with Synapse in Fabric? Or just the PBI gateway will suffice?
Windows VM is a pain in the ass for both M/A perspective and cost.
Very useful and clear, thanks for sharing!
Thanks!
Really great summary
Right now with a premium capacity Microsoft is providing 100 TB storage. Any new in storage they will give for onelake?
Also anything on how to track additional charges apart from capacity we are paying and for which onelake.