Forum Discussion

chienim's avatar
chienim
Frequent Visitor
9 years ago
Solved

Security aspect: Direct Query vs import

Hello,   Recently I'm playing Power BI with data and reports, This is a general question: From Security point of view, is there any advantage or disadvantage, between using DirectQuery or Import?...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    chienim

     

    As you said, using import security can be filtered at Power BI level since the data has been loaded into Power BI Desktop. And for direct query, the security is controlled on data source side. There's no other functional different on security aspect. For choosing direct query or import, you need to consider the data amount (1GB limit for dataset size) and refresh frequency. Please refer to a blog below:

     

    Power BI – Live connection vs. Import, comparison and limitations

     

    Regards,

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
9 years ago

chienim

 

As you said, using import security can be filtered at Power BI level since the data has been loaded into Power BI Desktop. And for direct query, the security is controlled on data source side. There's no other functional different on security aspect. For choosing direct query or import, you need to consider the data amount (1GB limit for dataset size) and refresh frequency. Please refer to a blog below:

 

Power BI – Live connection vs. Import, comparison and limitations

 

Regards,

niroberts's avatar
niroberts
Frequent Visitor
9 years ago

Taking this question a bit further.  As an admin I would like to prevent end users from importing data directly via the "get data".

1. Is there any way to secure the Import vs. Direct Query functionality?  In other words can I disable "import"?

2. Are there other methodologies for achieving the same end?  In other words can we prevent specific types of data sources at the Power BI level - or (in a simple scenario) do we modify the DB security to prevent direct connection to underlying tables and only allow access to views in a DB or a tab / olap model in SSAS...?

 

Thanks for any advice around security concerns between developers and users.  Our goal is to give the user as much self-service functionality as possible without constantly "importing" the same or similar data sets in an enterprise implementation.

 

Thanks again,

Nick

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    1. Is there any way to secure the Import vs. Direct Query functionality?  In other words can I disable "import"?

     

    Has this question been answered in the meantime? 

    Would be also relevant for me.

     

    Thanks, 

    Bettina