topic Is There A Way To Export .PBIX Files To .CSV Past 30k Rows? in Developer

Is There A Way To Export .PBIX Files To .CSV Past 30k Rows?

igreenjay — Wed, 08 Nov 2023 00:23:44 GMT

Current Situation: working on a page that embeds power bi reports using .pbix files and has actions that allow for users to export their reports as CSV or PDF. We are exporting to CSV data via the Javascript SDK and exporting to PDF using the API.

Issue: Exporting CSV data is limited to 30k rows by the SDK, and there is no way to either know how many rows there are in the dataset using the SDK and there is no way to offset the data to get data from [row n -> row n + 30k]. There are filters and slicers for rearranging the data, but they don't allow for an easy traversal of data to consistently get all of it. Also, trying to export using the API isn't possible because we are using .pbix instead of .rdl files for the embedded reports.

Question: Is there truly no way through either the Javascript SDK or REST API to export data from a visual not present in the first 30k rows from a .pbix report or am I missing something?

Re: Is There A Way To Export .PBIX Files To .CSV Past 30k Rows?

lbendlin — Mon, 13 Nov 2023 01:48:14 GMT

Consider running DAX queries against the dataset instead. The row limits are much higher and can be modified in the capacity administration.

Re: Is There A Way To Export .PBIX Files To .CSV Past 30k Rows?

igreenjay — Mon, 13 Nov 2023 21:42:37 GMT

Hi, I appreciate your response, but it is not really an answer to the question I was asking. I am working under specific limitations as listed in the question. Thanks though!

Re: Is There A Way To Export .PBIX Files To .CSV Past 30k Rows?

Anonymous — Mon, 27 Nov 2023 07:29:29 GMT

Hi igreenjay ,

Thanks for reaching out to us with your problem. Base on your description, it seems that you are trying to export the data with 30k rows. The following links are the threads which has the similar requirement as yours, hope they can help you resolve the problem.

Using R or Powershell:

Solved: Export huge amount of data from one pbix-file and ... - Microsoft Fabric Community

In follow up, you might also try using R to export the data from your .pbix file as explained here: https://community.powerbi.com/t5/Community-Knowledge-Base/Export-dataset-into-a-file-from-Power-BI-D...

you can try this, it is using powershell, i tried it myself with 8 millions rows, and it worked.

https://github.com/djouallah/PowerBI_Desktop_Export_CSV

Using DAX Studio:

Exporting Data from Power BI Desktop to Excel and CSV – Part 1: Copy & Paste and DAX Studio Methods - BI Insight

Best Regards