Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Security concern on exporting data from Power BI report with Direct Query

Hi,

 

I have a question regarding exporting data from a Power BI report made under direct query. We have some security concern over our data so we are using direct query option to develop our reports. As the direct query option does not store any data in the report i have a question that how it export data to Excel/ CSV? Does this imply anyone who get the access to our reports can export data?

 

Regards,

Maddy

  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    Hi Anonymous,

     

    I'm afraid that you have a little misunderstand of Direct query and export data option.

     

    If we could create the visual, we should export data from the visual. 

     

    Though we use direct query, it seems like that use T-SQL query to get the data, so we could export the data of the visual. 

     

    If you consider security, I'll suggest you could disable the option Export data in Power BI Service.

     

     

     

    Best  Regards,

    Cherry

2 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    7 years ago

    Hi Anonymous,

     

    I'm afraid that you have a little misunderstand of Direct query and export data option.

     

    If we could create the visual, we should export data from the visual. 

     

    Though we use direct query, it seems like that use T-SQL query to get the data, so we could export the data of the visual. 

     

    If you consider security, I'll suggest you could disable the option Export data in Power BI Service.

     

     

     

    Best  Regards,

    Cherry

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi Cherry,

       

      Thanks for the reply. Actualy we cannot disable that option in the Admin Portal as we are using Power BI Live Connection (Power BI datasets) . So far what we have done is that disabling data export option in the report.

       

       

      Now some users have requested they need to export data from the reports.

      Thanks for the explanation. It is clear that it doesnt store data in the report. Just querying the database to get data.

       

      Regards,

      Maddy