topic Re: Download Table view Data Using Button in DAX Commands and Tips

Download Table view Data Using Button

Anonymous — Wed, 28 Aug 2024 18:04:57 GMT

Hi,

I have a requirement to disable the export data option on live reports and provide a button that will do the same. The report table data should download when this button is clicked.

any suggestions? It's pretty urgent

Thank you

Re: Download Table view Data Using Button

monica345 — Fri, 30 Aug 2024 04:41:19 GMT

Hello,

Remove Export to Excel/CSV: In the Power BI Desktop, go to View -> Data View, and right-click on the table you want to disable exports for. Uncheck Export Data: In the Properties pane, uncheck the Export Data option. Create a Custom Action: In the Power BI Desktop, go to View -> Data View, right-click on the table, and select New Custom Action. Define Action: In the New Custom Action dialog, give the action a Patient Gateway name and define the logic to download the data (e.g., using a REST API call or DAX query). Add Button: Add a button to your report and assign the custom action to it. Develop a Custom Visual: Create a custom visual that replaces the default table visual and disables the built-in export functionality. Implement Download Button: Add a button to the custom visual that triggers the download functionality when clicked.

Re: Download Table view Data Using Button

Krina234pestro — Fri, 30 Aug 2024 04:37:43 GMT

Hello,

To achieve this, you can follow these steps:

Disable the Export Data Option:
If you’re using Power BI, you can disable the export data option for specific reports by going to the report settings and setting the “Export Data” option to "None".
For ASP.NET Core Report Viewer, you can hide the export options using the exportOptions property.
Create a Custom Download Button:
You can add a custom button to your report or web page that triggers the download of the table data. Here’s a basic example using Javascript&colon;

<button id="downloadButton">Download Data</button>
<table id="dataTable">

</table>

for (var i = 0; i < rows.length; i++) {
var cells = rows[i].cells;
var rowContent = [];
for (var j = 0; j < cells.length; j++) {
rowContent.push(cells[j].innerText);
}
csvContent += rowContent.join(',') + '\n';
}

var blob = new Blob([csvContent], { type: 'text/csv' });
var url = window.URL.createObjectURL(blob);
var a = document.createElement('a');
a.setAttribute('href', url);
a.setAttribute('download', 'table_data.csv');
a.click();
});
</script>

This script will create a CSV file from the table data and download it when the button costcoess is clicked.