Skip to main content
Microsoft Idea

Power BI

Needs Votes

Allow select only granted columns in Navigator screen of Get Data with SQL Server

Vote (1) Share
Nguyễn Minh Trí's profile image

Nguyễn Minh Trí on 23 Feb 2018 12:09:12

When getting data with SQL Server data source, if there are some tables that's configured "Deny" of Select permission, it will be invisible in Navigator of Get Data, but in Column Level, we don't have this feature. Preview screen will get all columns. In this case, if we set one and some columns as Deny permission, it will prevent us get data cause these columns deny permission, but in fact, we should be allow to select another granted columns.

I hope visible ability for "deny select column" will be added to PBI Desktop. Although we could use plain sql query in Additional area, but this is workaround solution and we will lose query folding if following this approach.