Entities permissions in Dataflows

[uberdube]

Hi,

Just wondering if anyone knows if there's a way to only select (or set permissons on) particular entities to be made available inside a dataflow (when creating a new datasource with 'Get Data'), rather than all existing entities being displayed?

More specifically, I only want my calculated enties to be available for use within a dataflow, but not show the linked entities from which those calculated entities have been created.

I understand that you aren't able to simply untick 'Enable Load' on the linked entities since they are required to successfully refresh the downstream calculated entities that reference them?  (please correct me if that's wrong!)

Cheers 🙂

[Anonymous]

Hi @uberdube ,

Please check the below article and see if it solved your problem.

https://ssbipolar.com/2019/06/21/quick-tip-restricting-access-to-linked-entities-in-power-bi-dataflo....

Hopefully works for you.

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[uberdube]

Hey @Anonymous  thanks very much for the article 🙂 I'm almost happy to accept this as a solution, however there's just one small thing that playing on my mind still, as I haven't found any reading on this yet either..

Usually Linked and Calculated Entities have the respective Icons and descriptions , as per below:

..but when disabling 'Enable Load'... the tables seem to change back into general 'Tables':

I'm just wondering if disabling the Linked entities is actually interfering with the way entities are processed (for example, will the entity now still use the Enhanced Compute Engine functionality to process)?

I'm still finding it hard to fully understand exactly what's actually going on under the covers with Dataflows even after all the reading I've done so far..! 😞

Cheers

[Anonymous]

Hi @uberdube ,

In my opinion, uncheck "Enable Load" will cut off the link between Linked entities and your calculated enties. Which means your calculated enties will not be refreshed if Linked entities are refreshed.

Currently, Linked entities can't be hidden if they are enable load, you can submit your idea to microsoft if you want: https://ideas.powerbi.com.

For more information about Linked entities, please check below document:

https://docs.microsoft.com/en-us/power-bi/service-dataflows-linked-entities

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[crocus]

If the Linked Entity and Calculated Entity are in the same dataflow then the data refresh still occurs. Unchecking "Enable Load" will only hide it from outside the dataflow, so another dataflow cannot use it say.

I have been using this method for data that shouldn't be seen by users, ie. summarizing it in another Entity and unchecking "Enable Load" in the Linked Entity.