Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Cross data in power bi services

Good evening dear,   I am having a serious problem at the company I work for. We create a sales report which is fed from a SQL database, and we publish it in power bi service in an application crea...
Anonymous's avatar
Anonymous
Not applicable
6 years ago
That client X is separated from Y by a statement in sql, in the database, each user has an assigned ID. Does not use RLS security
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
6 years ago

I don't think that is a viable or secure setup.  Have a hard look at potential browser cache issues, potential Content Delivery Provider issues  and potential query caching on your source.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I explain a little more the subject.
    It has happened to us that being logged in with a user X in PowerBI, PowerBI Gateway sends the information to the SQL Server as if user Y were connecting.
    Although it is working, it happens that when at the same time there is more than one user connected, we find that:

    1) the PowerBI Gateway service no longer respects the user issuing the query
    2) or, the PowerBI service is sending the information in the wrong way to PowerBI Gateway

    PLEASE, ANY OPINION ABOUT IT?

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      6 years ago

      1) is standard operating procedure for the gateway. You need to change your setup if you want it to behave differently.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        To the commented:
        1) is a standard operating procedure for the gateway. You need to change its settings if you want it to behave differently.
        What would those configurations you tell me about? Could you help me with a list of the configurations that you indicated?
        Other things, no less, we are using RLS at the database level, and this way of working is what brings us problems.

        Regards.