Module 4 (Part 2)

Question 1

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.

Answer 1

You must enter your email address and password.

Question 2

When exporting 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 have 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 does not respect filters on the list page, and won’t allow you to edit the records in Excel and publish them back to Business Central.

Open in Excel does not respect filters on the list page, and does not allow you to edit the records in Excel.

Answer 2

Edit in Excel respects most filters you have set in Business Central, and allows you to edit the records in Excel and publish them back to Business Central.

Question 3

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 will be 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 will be 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.

Answer 3

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 will be returned by the default filter Business Central uses.