Skip to main content

Power BI

Needs Votes

Don't limit download data file sizes

Vote (295) Share
's profile image

on 10 Oct 2017 23:28:59

Don't limit download data file sizes

Right now I need to be able to download a large csv from Power BI desktop and I'm getting the error message: "Data Exceeds the Limit" and "Your data is too large . Some data sampling may occur". And right now the table doesn't even appear to be that large: 6 columns x 811 rows.

Idea: Please remove the governor on the ability to download large CSV files.

Comments (29)
's profile image Profile Picture

7bc0aefe dfd4-4c2b-a578-c72982210737 on 06 Jul 2020 00:16:21

RE: Don't limit download data file sizes

Although I Voted here, but since I could not export from desktop, I thought it is not possible from Service also. But this is not the same. I think, service can export data more than 30k limit.
My concern was export limit from service which is already available.

's profile image Profile Picture

d1c37b7e 7c98-44f1-a3a7-9171f6e64411 on 06 Jul 2020 00:14:41

RE: Don't limit download data file sizes

Most of my teams' clients have as a basic ask, the ability to export underlying data. This limitation of 30k Rows (in addition to the inability to access underlying data if measures are used) is often a major determinant in deciding whether to build in Power BI or another program.

's profile image Profile Picture

ff31b67c 5470-4d4f-b319-98787b4dbf2d on 06 Jul 2020 00:13:50

RE: Don't limit download data file sizes

Please fix this. Users expect to export tables to excel.

's profile image Profile Picture

09732408 c124-45d2-be82-e923967b71c3 on 06 Jul 2020 00:13:05

RE: Don't limit download data file sizes

Please address this issue!

's profile image Profile Picture

4dab8f92 2f58-4d7c-bf51-e12fc2c32832 on 06 Jul 2020 00:11:46

RE: Don't limit download data file sizes

Please adress this issue!

's profile image Profile Picture

b87b1be6 94f5-4069-950d-21a5862d51fe on 06 Jul 2020 00:09:01

RE: Don't limit download data file sizes

....and now I need soemthing else. Bye.p.s. I Dont have time to work out what "data sampling" is taking place and how risky that might be for our end use!

's profile image Profile Picture

5c04c441 a38d-417c-a6b7-faf2172af473 on 06 Jul 2020 00:08:37

RE: Don't limit download data file sizes

This is just such a solution killing limitation.
Please provide some way, any way to both export the results of a visualization
AND
To automate

My company pays for the entire suite of tools, for a huge user base and this limitation just totally kills some really killer applications of using the office suite of tools.

It's really really frustrating.

's profile image Profile Picture

de774e6c 114f-4791-beb8-27340c64a84e on 05 Jul 2020 23:56:28

RE: Don't limit download data file sizes

I could understand if you are using the free version, but this is not acceptable as a paid Pro license user. This is not ready for prime time. Power BI is a shiny toy and shows Microsoft is just another company failing at hosted Enterprise services. Still, I'm sure there are enough C-level suits that are buying into Azure this year to keep them afloat. I will recommend only on-premise solutions.

's profile image Profile Picture

c8f67cd8 b4e6-4050-a03e-4a8c2d7396cb on 05 Jul 2020 23:54:44

RE: Don't limit download data file sizes

needs to be at least 1 million rows - even if you have to set it on a scheduler if resources are the issue. Fundamentally required to provide evidence behind decisions.

's profile image Profile Picture

ed543a60 42b9-417f-8f63-459c71106116 on 05 Jul 2020 23:43:04

RE: Don't limit download data file sizes

You shouldn't limit a paid service where accurate data is imperative. We are trying to use PowerBi as an Enterprise solution.