This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
What information is required to connect to a Business Central content pack?
You must provide an OData feed URL, and select Windows as the authentication method.
You must provide an OData feed URL, and select Basic as the authentication method.
Power BI can automatically connect to Business Central.
You must enter your email address and password.
When you export list page data to Excel, what is the difference between the action Open in Excel and Edit in Excel?
Edit in Excel respects most filters you've set in Business Central, and allows you to edit the records in Excel and publish them back to Business Central.
The Open in Excel option respects filters on the list page, and allows you to edit the records in Excel and publish them back to Business Central.
Edit in Excel doesn't respect filters on the list page, and doesn't allow you to edit the records in Excel and publish them back to Business Central.
Open in Excel doesn't respect filters on the list page, and doesn't allow you to edit the records in Excel.
How can you make sure you can see your Power BI report in a specific list page in Business Central?
Save your report with the name of the list page that you want to display the report in, so that when the report selection page is opened from a list page, it's returned by the default filter Business Central uses.
Save your report with the name of the workspace that you want to display the report in, so that when the report selection page is opened from a list page, it's returned by the default filter Business Central uses.
When you save your report, you need to upload it to the list page where you want it to become visible.
You must answer all questions before checking your work.
Continue
Was this page helpful?