Forum Discussion

urraghu's avatar
urraghu
Frequent Visitor
6 years ago

PowerBi gateway - Data integrity and least privilege

I am using PowerBI gateway to connect to on-premise sql DB and import the data(in few tables) for creation of reports. Everything was setup successfully... But there are few security concerns raised ...
Need Help
v-xuding-msft's avatar
v-xuding-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi urraghu ,

It is not supported for data gateway. If you import data in Desktop and then publish to Service, you could use use T-SQL queries to return specific data.

Reference: 

Power BI Introduction: Working with SQL Server data in Power BI Desktop — Part 5 

 

If you want to hide data for different users, you could try RLS. Please reference:

Row-level security (RLS) with Power BI 

(Note: It is based on rows rather than columns. If use it, we need to transform data firstly)

 

urraghu's avatar
urraghu
Frequent Visitor
6 years ago

Hi v-xuding-msft 

 

Thanks for your response.

to eliminate this unwanted data exposure to PowerBi data gateway , We are thinking to eliminate the data gateway completely by pushing the data first to azure sql from one-premise sql (as an intermediatry step ) and then connecting get data to Power BI directly from Azure SQL. 

 

do you also think this would be a better option in aspects of least privilage and data integrity ? any inputs/ideas on this would be appreciated. Thank You.