Data Exceeds the limit Error while Exporting Data

[aroloyefolajimi]

Hi Everyone,

Just tried using Export Data in the More Options tab and i got the notification below

The file exported had a lot of duplicates and it was not up to the row on Power BI,

How can i solve these?

[Harsh]

Hello @aroloyefolajimi,

Thank you for posting your query onto the Forum.

This warning is shown because in Power BI there’s only a limit of 150,000 rows that you can export the data but still you can achieve this through coding or some other options. I’m providing few links where this same type of query was asked onto the forum earlier and how it was resolved.

Please go through this links and follow the steps as shown in them and you’ll be able to export the data more than the specified limit.

Hoping you find this useful.

Thanks & Warm Regards,
Harsh

How can we export to excel from visuals more than 150,000 rows data?

how can we export to excel from visuals more than 150,000 rows data ? I am using Power BI Pro account… I need solution please help.

Export dataset into a excel file from Power BI Service about 150k rows data?

To the contributor of this post. Thank you for sharing your experiences around Power BI, please don’t hesitate to add more discussion or add value to wherever you think you possess the experience or knowledge that can help others in our Ecosystem Group. You can also help us in improving the Support forum further by answering the Enterprise DNA Forum User Experience Survey. We appreciate the initiative and your help in this group!

[aroloyefolajimi]

Thanks @Harsh Will check it out

[EnterpriseDNA]

Hi @aroloyefolajimi , did the response provided by @Harsh help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark the thread as solved. Thanks!