on 08 Nov 2018 18:34:36
The new Dataflows concept looks really interesting and holds massive potential to change the BI landscape.
Currently linking dataflows is only applicable to Premium licences. Based on how Dataflows are pitched as an Excel type approach to ETL I find it unusual that linked entities are only appropriate for Premium licences, especially since the analogy of an entities is a 'cell' in Excel. This is like shipping Excel with only one cell in it as a product for non-premium users. Premium capacities are only appropriate for huge organisations with hundreds of licences to make it financially viable. I would consider either a) making linked entities available to Pro licences by default. or b) separating the licencing for dataflows out of premium into a piece that smaller organisations can utalise in a separate licence type.
- Comments (15)
RE: Dataflows linked entities Pro Licence
This is a good example of a disturbing trend in PBI licensing, with really valuable features gated behind Power BI Premium. For instance, Tableau is actually cheaper for smaller organizations that want an on premises product.
Given how it's priced, PBI Premium should be about capacity, features should by and large be the same across Pro/Premium. Orgs that are not close to 500 users are not going to consider paying $5K/mo for extra features!
RE: Dataflows linked entities Pro Licence
I totally agree with what is posted in the comments here !
RE: Dataflows linked entities Pro Licence
With the Pro-licence I currently still need some kind of data warehouse in addition to Power BI in combination with the data flow functionality. Without a data warehouse it would be unmaintainable to have all the different reports fueled with (mostly) the same data.
Dataflows could have the possibility to change that by linking and combining different entities thus giving me the chance to make a layered ETL process.
At the moment this is the root cause for TWO OF OUR CUSTOMERS to NOT CHANGE TO POWER BI.
RE: Dataflows linked entities Pro Licence
I have spent the day combining loads of existing queries into a single entities today due to this restriction. However, am aware this creates large potential for repeated logic throughout lots of my queries, just because linked entities is not possible. Not tidy, however showing potential still. Also, I tend to have quite a few custom functions that I build, and I am finding I am wrapping and repeating these within my queries now just to get around this licence restriction. The difference in costs between Pro and Premium is just insane. I would think that the load on Microsoft's services is more intensive by putting these restrictions in place - Incremental refresh is just another example where their servers could just refresh a few days of data instead of the years of historical data I am finding I am refreshing 8 times a day. Hopefully one day this is addressed, as Power BI has opened a can of worms of small company analysts driving some massive value for their organisations, instead of just large multi-national companies requiring large scale BI solutions.
RE: Dataflows linked entities Pro Licence
This is also an immediate pain point. Dataflows is a powerful tool and will be extremely useful for smaller business, for whom even the entry level of Premium capacity is out of reach. Please find a way to address this.