Queries are supposed to be performant!

Business Central/NAV General Discussions
1

Hello Everyone,

I’m facing performance issues with queries in Business Central when handling large datasets. Despite trying Smartlists and importing data in Excel from OData feed… The data generation process was extremely long and time-consuming.

Could anyone share Microsoft’s recommendations for improving performance in such scenarios? Additionally, I’m curious about the most effective reporting tools compatible with Business Central SaaS.

Appreciate any insights or suggestions.
Thank you.

2

Here’s some info about the ways to get data for reporting in BC.

Looks like the only real way to export data is using OData. If that’s indeed the case, then exporting to a data lake or a Power BI dataflow would be a good idea. It’d allow you to extract some slowly or not changing things (like transactions) and then only download new transactions or changed transactions (based on modified or created date) to increase performance.