Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
AdamJay
Regular Visitor

Exporting to Excel, data limit

Hi all, I work for a local government authority (so I cannot post any of the data here) but we have been using power BI to create tailored reports for data imported from other software via SQL.

For the reports we have been building we have been using the table visual to filter through the data and get information from different data tables, and the data shows up in the table.

 

However, we have noticed as we added more columns the amount of data that was exported (via clicking on the 3 dots, and export data) we were getting fewer rows in the data export. When we then removed some of the columns we started getting more data in the export, however we need the data from these reports.

So my question is, what is the factor/limitation to data exports? Is it the number of records, or perhaps number of characters?

I have looked for an answer for this, however I have not found an answer, one said maximum export size of 16mb, but our report is 767kb so that is not the case here, and the only limitation to limited characters I could find was in the millions per cell, and 30k rows for free users, and 150k for pro (please note I am a pro user). Also just to note there are no 

As a work around we have been using multiple tables on the same report page connecting them via an id number, and then doing Vlookup within excel. Is this really the best way to do this?

 

Any assistance would be great.

Many thanks.

2 REPLIES 2
Idrissshatila
Super User
Super User

Hello @AdamJay ,

 

What you could do is connect to your power BI dataset from excel and build the report you want using the data you have in Power BI.

https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel

 

If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos 👍

Follow me on Linkedin



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Hi, thanks for the response.

Unfortunately your suggestion would not work. We are working with so many tables and so much data that this would be virtually impossible to use excel as for source for data importing, which is why we started using Power BI.

We basically need to work out how much we can trust power bi’s data exports and if there is any way around these issues.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.