Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
| Enabled for | Public preview | General availability |
|---|---|---|
| Users by admins, makers, or analysts | - | 
Oct 1, 2024 |
Business value
Advanced Power Query users can now fine-tune how the Power BI connector for Business Central works in their semantic models. New parameters for the Power BI connector for Business Central give you more flexibility, better performance, and an improved user experience for data integration and analysis. The default values still work well in most cases. With these parameters, you get more control over your data interactions, so data processing is more efficient, performance is better, and the user experience is enhanced.
Feature details
Starting in this release, the Power BI connector for Business Central supports several advanced properties that you set in your Power Query queries:
AcceptLanguage: Use this parameter to specify preferred languages for responses. With this parameter, users receive messages and translatable strings in their desired language. This parameter improves user satisfaction and makes the data more accessible and relevant. For more information, see Load a report in Power BI.
ODataMaxPageSize: Limit the number of entities in each results page to add flexibility when you connect to large datasets or use complex queries. This parameter keeps data retrieval efficient and responsive, so you get faster insights. You can't set a value higher than the maximum page size the service allows. For more information, see ODataPreferenceHeader.MaxPageSize Propert.
Timeout: Set the maximum duration for a request before it times out. This parameter helps manage system resources and stops long-running queries from affecting system performance. Users see minimal delays and interruptions, so workflows stay smooth. You can't set a value higher than the timeout the service allows. For more information, see OData.Feed.
UseReadOnlyReplica: This parameter controls whether requests go to the primary database or a read-only replica. When you offload read operations from the primary database, you boost performance. This approach provides faster data retrieval and better system stability, especially during peak usage times.
Geographic areas
Visit the Explore Feature Geography report for Microsoft Azure areas where this feature is planned or available.
Language availability
Visit the Explore Feature Language report for information on this feature's availability.
Additional resources
Building Power BI reports for displaying Dynamics 365 Business Central data (docs)