RE: Power BI limits or BC limits
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
