We're having a problem with refreshing database in our raports based on Miltitenant SQL Database.
We have same raports for two companies (they have different, unique login and password for their tenant), and when we refresh the data in PowerBI Desktop everything is OK. When we publish raports to PowerBI Service and we're refreshing the data one raport is OK, but sometimes the secound one have data from the first company! (Due to raport filter there is nothing to see at first, but when we clear filters we can see that this is wrong data). How this is possible? Is there something we can check before? Why PBI Destop works fine, but on Service there is some problem?