Forum Discussion

uberdube's avatar
uberdube
Advocate IV
6 years ago

Entities permissions in Dataflows

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 🙂

4 Replies

    • uberdube's avatar
      uberdube
      Advocate IV

      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's avatar
        Anonymous
        Not applicable

        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.