Skip to main content

Notifications

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 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.
 
  • 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,906 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 336 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,906 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 931 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
    FLMike Profile Picture
    FLMike 29,371 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

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #9 Get Recognized…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,316

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,290

Leaderboard

Featured topics