448
Hi all,
I try to have some report from my BC365.
Creating my report for production and bill of materials, I import 22 tables and all is fine, but when I launch an update after a long elaboration, Power BI return errors often not the same, as not enought memory, error of line in table and not always in the same tables.
It's few time that I work with Power BI and BC and I think that I'm mistaken something.
Please can somebody give me some help or some suggestion about this problem?
Hi, Personally I feel this is a Power BI issue. There is also a similar discussion below.
The following are some limits in BC, hoping to give you some reference. I suggest that you add some filter conditions when fetching the table, reduce the amount of data, and see if this problem still occurs.
Operational Limits for Business Central Online
Current API Limits
Hope this helps.
Thanks.
ZHU
Are you using Business Central on prem or BC online?
If you are using BC online you should have your partner raise a support ticket to Microsoft around this issue.
hi
It sounds like you are encountering some performance and memory issues when trying to create your report in Power BI. Here are a few suggestions that may help you troubleshoot the issue:
Optimize your data model: If you are importing a large number of tables into your report, make sure to optimize your data model to reduce the size of your data set. You can do this by removing unnecessary columns, filtering out irrelevant data, and aggregating data where possible.
Limit the number of records: Consider limiting the number of records that are imported into Power BI, particularly if you are working with a large data set. You can do this by using filters or slicers to limit the data that is displayed in your report.
Increase your memory settings: If you are getting memory errors, try increasing the amount of memory allocated to Power BI. You can do this in the Options menu by selecting Options and Settings > Options > Data Load > Load settings, and then adjusting the Memory settings.
Use incremental refresh: If you are working with a large data set that does not change frequently, consider using incremental refresh to improve performance. This feature allows you to only load new or updated data into your report, rather than reloading the entire data set.
Check for errors in your data: If you are encountering errors in specific tables, make sure to check the data in those tables for any issues or inconsistencies. You may need to clean up your data or make adjustments to your data model to address these issues.
Break your report into smaller sections: If you are still encountering errors after trying the above suggestions, consider breaking your report into smaller sections or creating multiple reports that focus on specific areas of your data.
DAniele
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (