Power BI Refresh Issue with Business Central Data Source

[govind_021]

Hi Everyone,
I'm reaching out to check if anyone else is experiencing issues with Business Central as a data source for Power BI reports.
Lately, my report refreshes are either timing out or taking up to 2 hours to complete.

I've already tried most common optimization techniques, but the problem still persists.
Is anyone else facing similar issues, or has any insight into what's going on?

Thanks in advance!

Best Regards
Govind Sapkade ( Microsoft Certified Data Analyst , PL 300 Certified , MS Fabric Enthusiast)
Let's Connect
Linkdin - www.linkedin.com/in/govind-sapkade-845104225
Youtube - http://www.youtube.com/@govind_dataanalyst

[v-ssriganesh]

Hello @govind_021,

Hope everything’s going great with you. Just checking in has the issue been resolved or are you still running into problems? Sharing an update can really help others facing the same thing.

Thank you.

[v-ssriganesh]

Hello @govind_021,

We hope you're doing well. Could you please confirm whether your issue has been resolved or if you're still facing challenges? Your update will be valuable to the community and may assist others with similar concerns.

Thank you.

[v-ssriganesh]

Hi @govind_021,

Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to @jaineshp for sharing valuable insights.

Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.

Thank you for being part of the Microsoft Fabric Community.

[jaineshp]

Hey @v-ssriganesh,

Thank you for the kind recognition - always happy to contribute to our community's success!

Best Regards,
Jainesh Poojara | Power BI Developer

[jaineshp]

Hey @govind_021,

Business Central’s OData can get slow with large datasets or joins, consider breaking out your model or using incremental refresh if you're in Premium workspace.

Fixed? ✓ Mark it • Share it • Help others!

Best Regards,
Jainesh Poojara | Power BI Developer