Data Storage and Connection for Power BI Service

Hi pennyhoho117 

Key Points for Secure Power BI Setup:

1. Secure Data Transmission: Power BI uses TLS encryption for data in transit and encryption at rest for stored data. Use Row-Level Security (RLS) for sensitive data access.

2. Data Storage in Power BI:

   • Import Mode: Data is stored in Power BI Service (encrypted in Azure).
   • DirectQuery Mode: Data is queried live, not stored in Power BI.
   • Live Connection: Connects directly to models without storing data.

3. On-Premises Data Gateway:

   • Required if Redshift or PostgreSQL are in a private network or on-premises.
   • Acts as a secure bridge between Power BI Service and your databases.
   • Supports encrypted connections for scheduled refreshes or real-time queries.

4. Recommendations:

   • Use DirectQuery for Redshift/PostgreSQL to avoid storing data in Power BI.
   • Set up an on-premises data gateway for secure, private database connections.

Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS