Data Exceeds the limit Error while Exporting Data

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?

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. :slightly_smiling_face:

Thanks & Warm Regards,

Thanks @Harsh Will check it out

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!