Data access and Direct Query?

[Cookistador]

Hello,

I am working on a tableau migration, and the IT Sec would like to have the same beahaviour that the one they have in tableau:

if a user does not have access to the sql database, they are not allowed to see the reports visuals...

So according to this prerequisites, I can forget Import mode, so I would like to know if Direct query can meet this expaction? 

Is it possible to set up the direct query to use the users credetials to execute the query?

For the moment, I set up a data gateway but in the near future, they will use Azure sql database

Many thanks for your help

[Miszel8 · Accepted solution]

Hello,

the short answer is yes:

you need to make use of this option:

you can learn more here: https://learn.microsoft.com/en-us/power-bi/connect-data/service-azure-sql-database-with-direct-conne...

The long answer is: you should not go in the direction of DQ Only because it used to be like this in Tableau!

You can make the use of your security broader for example: create some Entra ID groups, who can both have the access to the SQL DB and have the access to the given PBI Workspacs/apps using this SQL DB as the data source.

You can also think about RLS/OLS in your PBI Semantic Models if it's needed.

In long run it is less expensive to setup the proper security at the begining of your migration and use Import Mode than move directly to Direct Query.

Good luck!

[Cookistador]

My first idea was to use Import mode and set up all the security with workspace(one workspace per team) but the data are highly sensitive and they want to avoid all data leak...