Forum Discussion

OrM's avatar
OrM
Frequent Visitor
4 years ago
Solved

Disable Create Report from the existing APP

Hi all!

 

So I recently realized that App's users can actually see the tables used for the report. If user click on 3 dots on top of the app and select 'See related content'.

On the pop-up window if they select Create Report (highlighted in red screenshot below), they will see all the tables and the only way to avoid it is to hide the tables. However, hiding and unhiding the tables is not really an efficient way to prevent end users to see all the tables.

 

Is there any other way to restrict end users to be able to see the tables and columns after following the steps above?

 

Thank you!

Best regards,

Orkhan 

 

 

  • Hi OrM 

    The app users are seeing the create Report icon because they have "build" permission, either through the App or on the underlying Datasets. To remove this, Update the App to remove the entry "Allow all users to connect to the app's underlying datasets using the Build permission." in Permissions. 

    Note though that this setting will be overridden if any of the users have "Build" permission on the underlying Dataset. To check this look at the "Manage Permissions" entry on the Dataset in the App Workspace. If any of the users have "Build" permission there remove it.

    Then without "Build" permissions they will not be able to create a new report based on the data, and hence won't be able to see the tables in the Dataset.

    Hope this helps

    Stuart  

5 Replies

  • Burningsuit's avatar
    Burningsuit
    Resident Rockstar

    Hi OrM 

    The app users are seeing the create Report icon because they have "build" permission, either through the App or on the underlying Datasets. To remove this, Update the App to remove the entry "Allow all users to connect to the app's underlying datasets using the Build permission." in Permissions. 

    Note though that this setting will be overridden if any of the users have "Build" permission on the underlying Dataset. To check this look at the "Manage Permissions" entry on the Dataset in the App Workspace. If any of the users have "Build" permission there remove it.

    Then without "Build" permissions they will not be able to create a new report based on the data, and hence won't be able to see the tables in the Dataset.

    Hope this helps

    Stuart  

    • OrM's avatar
      OrM
      Frequent Visitor

      Hi Stuart,

       

      Thank you for your reply. The "Allow all users to connect to the app's underlying datasets using the Build permission." is not ticked. But the users still can see the tables. 

       

      I suppose it has something to do with the access I gave them. I gave Direct Access to the report. Can this affect the visibility of the tables?

       

      Thank you!

       

      Regards,

      Orkhan 

      • Burningsuit's avatar
        Burningsuit
        Resident Rockstar

        Hi OrM 

        Yes, you have probably given "Build" rights to the users on the underlying Dataset in the App Workspace.

        To check this look at the "Manage Permissions" entry on the Dataset in the App Workspace. If any of the users are "Members" or "Contributors" they need to be changed to "Viewers" and if any "Viewers" have "Build" permission there remove it.

        Hope this helps

        Stuart

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Community Support

    Hi, OrM 

     

    I see that you haven't replied anymore, I don't know if your problem is solved.

    Regarding your description, let me add that you need to make sure that ‘Allow uses to buils content with the data associated with this report’ is not set.

    Did I answer your question ? Please mark my reply as solution. Thank you very much.
    If not, please feel free to ask me.


    Best Regards,
    Community Support Team _ Janey