Overview:

The "Download Button by JTA" is a custom visual designed specifically for Power BI users, empowering them to export large datasets effortlessly.

Key Features:

Enhanced Data Export: Download up to 300,000 rows and 15 columns of data in CSV format with a single click.
Customizable Interface: Tailor the visual interface to match your reporting style for seamless integration.

Benefits:

Overcome Power BI's limitations for exporting large datasets.
Streamline data access for deeper analysis outside Power BI.

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 se 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 enquiries@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.

Download Button by JTA

作者 JTA The Data Scientists