Forum Discussion

pennyhoho117's avatar
pennyhoho117
Helper IV
1 year ago
Solved

Data Storage and Connection for Power BI Service

Our company planning to use Power BI Serivice for reporting,and we have Pro License. Due to sensitive data consideration, can you advice the data connection way  which can keep data transmits secure...
Need Help
  • Poojara_D12's avatar
    Poojara_D12
    1 year ago

    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 

Poojara_D12's avatar
Poojara_D12
Super User
1 year ago

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 

  • pennyhoho117's avatar
    pennyhoho117
    Helper IV
    1 year ago

    if i use directQuery mode, can set Refresh schedule? as i know, Power BI Report Server does not support refresh schedule for directQuery mode, so Power BI service support refresh schedule when report with DirectQuery Mode?