Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi there,
I've come across a problem with how computed entities are shown in the Dataflow Query Editor.
The way a computed entity is shown to a user is through the use of a "lightning bolt" on the entity's icon, however, in some scenarios this lightning bolt doesn't appear, even though the entity is "computed". This can cause confusion when saving and closing the Dataflow Query Editor, and a message pops up saying "This dataflow contains computed entities, which require Premium to refresh. To enable refresh, upgrade this workspace to Premium capacity".
Funnily enough, the lightning bolt does show on the "Entities" page after you've closed the query editor. See the following photos:
The way that I got into this scenario is by creating a new blank query (Roles (2)), and inserting the following code:
However, from my investigation, any other table functions (e.g. Table.Group or Table.Transpose) that reference an entity directly (rather than via an intermiate step to the M query) don't show the lightning bolt even when they should. This can make it quite hard to diagnose when you're looking at complex queries.
Hope this makes sense.
Ed
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.