Power BI Service to Azure SQL Database Credentials Issue

[gajinder47]

So ,

We require to publish a single database (with Multiple credentials for each tenant/user as we are using SQL Row Level Security for limiting the row level view for each user) to Power BI service multiple times, Although as written each time the SQL credentials are different.

We will then share the Datasets through content Pack.  This whole setup was working absolutely fine  as we were able to see data that should only be visible to a certain user through RLS up until now.

Now when we publish the dataset it says the following although we are not using any Gateways (Enterprise or Personal) in our solution 

s

I think it is a big with either PBI Service or Desktop. Please let me know your understanding , Thanks for reading 🙂

[Eric_Zhang]

@gajinder47

Is Azure SQL DB the only database in your report? Can you check the dataset after published to see it actually uses a gateway or not?