Skip to main content

Power BI

Needs Votes

Perform DDL statements against databases before query

Vote (1) Share
Damian's profile image

Damian on 21 Nov 2016 17:30:03

Several databases are managed by roles which allow access or not to the tables. I have not been able to run the following DDL statement:

SET ROLE sampleRole;

If I don't run this statement before the query I don't have access to the tables.