Make .gzip files available for download in Power BI report

[f4b10_mutant]

Hello, community!

I’m facing a challenge in Power BI and would like to seek your assistance.

Currently, I’m working on a report where I need to make .gzip files available for download. These files are stored in a Blob Storage that uses an account key for access, but the end users of the report do not have this key, so I cannot expose that information.

In my semantic model, I’m using the Import method and have a table that contains the following columns:

• Name: which returns the path of the files within the container.
• Folder Path: which returns the link to access the container.
• Content: which brings the data in Binary format.

My goal is to allow end users to download these .gzip files directly from the report, without the need to decompress or manipulate the data.

If anyone has faced a similar situation or has suggestions on how I could implement this, I would greatly appreciate it!

I look forward to your advice!

Thank you!

[v-jialongy-msft]

Hi @f4b10_mutant 

Has your problem been resolved? If so, could you share your solution so that others with similar issues can benefit from it?

Best Regards,

Jayleny

[f4b10_mutant]

Hi @v-jialongy-msft,

Unfortunately, I haven't resolved the issue yet. However, I will definitely share the solution in this thread as soon as I find it.

Best regards!

[lbendlin]

Power BI is not a file storage tool. Best you can do is maintain hyperlinks to the actual file storage. But there you will run into authentication issues if the files are not accessible to the report user.

[f4b10_mutant]

Hi lbendlin,

I hope you’re doing well!

I completely understand that Power BI isn't designed for file storage. The challenge we're facing is that we need to provide analytical tables with millions of rows for our end users. Given the sheer volume of data, exporting directly from the report often leads to errors, especially with CSV files exceeding 400 MB daily.

We considered using Gzip compression to manage the data size, but we want to avoid the need for decompression to prevent the same issues from arising.

You're right about the authentication hurdles. I'm exploring whether Power Automate could help us navigate this situation. I'm just trying to find a workaround within the constraints we have.

Thanks again!