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 

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?

v-nmadadi-msft's avatar
v-nmadadi-msft
Community Support
1 year ago

Hi pennyhoho117  ,
Thanks for reaching out to the Microsoft fabric community forum.

Please check out this link and scroll down to the “Semantic models in DirectQuery mode”

Data refresh in Power BI - Power BI | Microsoft Learn

 

You wont be requiring refresh schedule as in DirectQuery Power BI doesn’t import data from source instead semantic model returns results from the underlying data source whenever a report or dashboard queries the semantic model.



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 give "Kudos"

Thanks and Regards