Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
Anonymous
Not applicable

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

1 ACCEPTED SOLUTION
v-piga-msft
Resident Rockstar
Resident Rockstar

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.

 

disable the option for export.PNG 

 

Best  Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-piga-msft
Resident Rockstar
Resident Rockstar

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.

 

disable the option for export.PNG 

 

Best  Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

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.

 

pbi.PNG

 

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

 

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors