Questions about the full process of Compression, Encryption in Publish report and Enquiry Data

[pennyhoho117]

i have asked question about data compress in Data compression Procedure - Microsoft Fabric Community

but i still confuse for the full process of Data Processing(Encrption and Compression).

1. For Publishing a report from local device.

    the process is : create file from Power BI desktop(local) > compress and optimize by VertiPag Engine(local) > Publish to Power BI Service > data encryption > How the imported data and report view being encrypted in Power BI Service? 

2. For an existing report in power BI Service, 

    the process is Data enquiry > Data encryption by data gateway> compress by VertiPag in Power BI Service?first encrypt then compress?

if the process is like this, then procedure is different from publishing report? <which is compress then encrypt>

3. the 1GB checking in Local? or in Power BI Service? What would happen if exceeds 1GB, 1GB means the pbix file size?(inlcuding the report view(visualization)?

4. For user open a report from Power BI service, what is the process behind? report view is cached? i mean the Data at Rest and Data in Store concept

[v-pnaroju-msft]

Hi pennyhoho117,

We are following up to see if your query has been resolved. Should you have identified a solution, we kindly request you to share it with the community to assist others facing similar issues.

If our response was helpful, please mark it as the accepted solution and provide kudos, as this helps the broader community.

Thank you.

[v-pnaroju-msft]

Hi pennyhoho117,

We wanted to check in regarding your query, as we have not heard back from you. If you have resolved the issue, sharing the solution with the community would be greatly appreciated and could help others encountering similar challenges.

If you found our response useful, kindly mark it as the accepted solution and provide kudos to guide other members.

Thank you.

[v-pnaroju-msft]

Thank you @Akash_Varuna for your response.

Hi pennyhoho117,

We would like to inquire if the solution offered by @Akash_Varuna has resolved your issue. If you have discovered an alternative approach, we encourage you to share it with the community to assist others facing similar challenges.

Should you find the response helpful, please mark it as the accepted solution and add kudos. This recognition benefits other members seeking solutions to related queries.

Thank you.

[Akash_Varuna · Accepted solution]

Hi @pennyhoho117 

• Publishing a report: Create in Power BI Desktop, compress with VertiPaq locally, publish to Power BI Service, and encrypt data at rest in the service. Power BI uses Microsoft-managed encryption by default, with an option for BYOK.

• Querying an existing report: Data is encrypted in transit via the gateway, then compressed by VertiPaq in Power BI Service. Publishing compresses first, then encrypts, while querying encrypts first, then compresses.

• The 1GB limit refers to the compressed data model size, checked during publishing. Larger datasets require a premium workspace.

• Opening a report: Data at rest is encrypted, report visuals are cached for performance, and live queries occur only if fresh data is needed.
  If this post helped please do give a kudos and accept this as a solution
  Thanks In Advance