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 created in the power bi service. We have 20 different clients, and the problem is that when we log in with user X (of a client) and then in an incognito window we log in with user Y (of another client), we see that the user's data And they are not correct, and at the same time the data of user X is observed in the Y. Let's say that the data is crossed. At the same time, when we update the report in the application, data is changed again. There are times when waiting a time of 10 minutes, everything is restored and the data is observed perfectly, but it may be that after a few minutes, the customer data is crossed again.

Please could you give me an idea of ​​what is happening? is it database issue? or is it a power bi service issue?

 

Regards.

7 Replies

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

    How do you separate client X from client Y - do you use Row Level Security on the dataset?

    • 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.