PowerBI for large lists in Excel

[Anonymous]

Hello,

I would like to have advice for my organization where I'm working now. They hired me as a PowerBI developer to make reports. But now I hear that the most employees don't need a report but need large lists in Excel to work with. I can make these lists in PowerBI but they are unaible to export it due the limitation of 150.000 records. How can I help them with use of PowerBI?

Thanks in advance.

[Anonymous]

Hello Shahfaisel,

I have considered it, but when trying it give also an error with too much data and the performance was very bad.

[Shahfaisal]

---

@Anonymous wrote:

I have considered it, but when trying it give also an error with too much data and the performance was very bad.

---

Yeah, Excel is not designed to handle large volumes of data easily. I would look at what users are doing with the data and come up with an alternate solution. If all they are doing is just exporting data from Power BI to Excel, then it kind of defeats the purpose of Power BI. 

Maybe create views in the database and provide users access to the views directly - this suggestion is already making me cringe; please try to understand the needs better and post a new question with all the details.

[Shahfaisal]

Have you considered Analyze in Excel? This blog post would be a good start to get up to speed - https://radacad.com/say-no-to-export-data-yes-to-analyze-in-excel-power-bi-and-excel-can-talk