Forum Discussion
Community ChampionDataflows and Sharepoint Lists. Issues with [List] Items
Hi DebbieE,
I think dataflow entity and online editor can't fully replace the local client editors.
AFAIK, dataflow use Power Query online environment which hosts on the cloud server. For performance, permissions, and security related reasons, it should have more limits on usage. You can take a look at the following link to know more about the limitations of PQO editor:
Power BI Security#data-storage-security
BTW, some of the advanced operations have been moved to the computed entity for better performance, you can refer to the below documents to know more about these:
Dataflows limitations and considerations
Regards,
Xiaoxin Sheng
- DebbieE
the major problem with the computed entity is that is appears to only be available in Premium which to me seems a bit ridiculous because we only want to use Premium for Production.
I cant do basic things like merging table in the dataflow because its not in Premium
is it a possibility that dataflows are a bit pointless usless you have premium capacity?
its beginning to feel that way
HI DebbieE,
As you know, power query online editor is host on the cloud server side. For this scenario, power bi will share some of the resources to simulate the editor and use it to execute its formulas.
The online version not the same as the desktop side, it not has enough permission and memory to execute all M query functions(some complex functions require a lot of resources, some of them executed very slowly).
For this scenario, these functions have been assigned to the premium license who has standalone server resources to execute with better performance and high permissions.Regards,
Xiaoxin Sheng
