Download Button by JTA

Overview:

The "Download Button by JTA" is a powerful custom visual for Power BI that enables users to export their selected data directly to CSV — quickly, easily, and without technical setup. Built with performance and flexibility in mind, it’s ideal for sharing insights beyond Power BI.

Key Features:

• Large-Scale Export: Export from 300,000 rows and up to 15 columns of data to CSV with a single click.
• User-Controlled Output: Only the columns added by the user are included — what you see is what you export.
• Customizable UI: Adapt the button’s style and layout to seamlessly match your report’s design.

Benefits:

• Bypass Power BI Limits: Overcome the platform’s built-in export restrictions for large tables.
• Enable Deeper Analysis: Empower end-users to continue their exploration outside Power BI using familiar CSV tools like Excel or Python.
• Frictionless Sharing: Make it easy for viewers to access curated data slices without needing edit access or DAX expertise.

Constraints:

The custom visual leverages the browser’s cache memory. It works by fetching data in chunks of 30k rows, storing each chunk in the browser's cache until the entire dataset is compiled for download. This incremental approach requires the use of browser memory to ensure seamless processing. Unfortunately, this means that the visual does not operate as intended in Power BI Desktop due to technical constraints and security restrictions within that environment and you must use the Power BI Service.

For the very same reason, there's a possibility that it may encounter limitations or restrictions in certain browsers. Each browser has its own set of security measures and permissions that can affect how our visual operates.

Extended Data Download:

If you have the need to download more than 300,000 rows, please send us a request at custom.visuals@thedatascientists.com. Our team at The Data Scientists will work with you to accommodate larger datasets, providing tailored solutions to meet your specific data export requirements.

Tutorial:

• 1. Create a measure with the number of lines you want to download.
• 2. Add it to the "Number of Lines" field.
• 3. Add all the columns you wish to download to the "Columns" field.
• 4. Click on the Download button.
• 5. Await while the request is processed.
• 6. Copy the provided link from the opened window.
• 7. Open a new URL window and paste the copied link into the address bar.
• 8. Press "Enter" to start the download process.
• 9. You will observe an Excel file being downloaded containing the requested data.

If you liked what you saw, you can try it for yourself and find more information here.