Skip to main content

Notifications

Announcements

🌸 Community Spring Festival 2025 Challenge 🌸
Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id : cwfO514aAwakFEqiCV9smz
Power Platform Community / Forums / Power Apps - Microsoft Dataverse / Dataverse table securi...
Power Apps - Microsoft Dataverse
Suggested answer

Dataverse table security - Users able to query from Power BI

Like (1) ShareShare
ReportReport
Posted on 2 Oct 2024 06:07:52 by JD-02100603-0 4
We have created a solution using Dataverse + Power Apps. We implemented all the security in the application (with Power Automate) since our use case had very complex requirements in terms of security and Business Units didnt adapt well to it. 
 
I tested with a few users and the users are not able to see the tables directly in the enviornment since we have limited actions to the security role. However, when connecting from Power BI the user is able to easily read all the tables and all the data in them.
 
Is there any way to configure the security group or enviornment so quering the data from Power BI is not possible at all?
 
Thank you
 
 
Edit:
 
After reading the documentation I found an option to disable TDS endpoint by default unless granted in the security role.
 
Categories:
Microsoft Dataverse
Tables
  • JD-02100603-0 Profile Picture
    JD-02100603-0 4 on 04 Oct 2024 at 12:30:23
    Dataverse table security - Users able to query from Power BI
    @Ibendlin. I already stated in the description of the question that using Dataverse out of the box security model is not an option for us now. 
     
    Fortunately there are different ways to secure the data and block endpoints using the security roles.
     
    I have already edited the question and it is possible to close the TDS endpoint for users who are members of a particular security group so they cannot query the SQL endpoint of Dataverse.
     
  • lbendlin Profile Picture
    lbendlin 7,777 Super User 2025 Season 1 on 04 Oct 2024 at 12:12:55
    Dataverse table security - Users able to query from Power BI
    Explain more about what?  Secure your data at the source, not at only one of the  downstream assets.
  • Suggested answer
    ankit_singhal Profile Picture
    ankit_singhal 457 Super User 2025 Season 1 on 04 Oct 2024 at 05:09:34
    Dataverse table security - Users able to query from Power BI
    Can you please explain more about this. If user are not able to see tables then they should not access the data as well. you can update your security roles and remove read access or may be give user level read access. 
  • lbendlin Profile Picture
    lbendlin 7,777 Super User 2025 Season 1 on 03 Oct 2024 at 13:21:00
    Dataverse table security - Users able to query from Power BI
     
    "since our use case had very complex requirements in terms of security and Business Units didnt adapt well to it. "
     
    So basically your Dataverse tables are wide open, and now you wonder why Power BI users take advantage of that?
     
    Secure your tables in Dataverse.
  • Shashank Bhide Profile Picture
    Shashank Bhide 934 Super User 2025 Season 1 on 03 Oct 2024 at 09:08:54
    Dataverse table security - Users able to query from Power BI
    that's weird, if they don't have read permissions on the tables (as themselves or through the team(regular or access) they are part of) then there's no way they should be able tor read the data.
  • Suggested answer
    Michael E. Gernaey Profile Picture
    Michael E. Gernaey 38,856 Super User 2025 Season 1 on 03 Oct 2024 at 03:05:35
    Dataverse table security - Users able to query from Power BI
    HI
     
    How exactly did you block the people on Dataverse from seeing the tables?
     
    are these custom or standard tables?
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge 🌸
Welcome to the Power Platform Communities

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,518 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,697 Most Valuable Professional

Leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans