RE: How to configure a connection between Power BI and Business Central On-Premises?
1.Select Get Data at the bottom of the left navigation pane.
You may also get starting from within Dynamics 365 Business Edition. From the role center, navigate to Report Selection in the Power BI Role Center part. Select either Service or My Organization from the ribbon. When either of these actions are selected, you will be taken to either the Organization gallery in Power BI or to the services library in Power BI, which will also be filtered to only display content packs related to Dynamics 365 Business Central .
1.In the Services box, select Get. This will open a page with the AppSource and Apps for Power BI apps.
2.Select Apps from the Apps for Power BI apps tab, choose the Microsoft Dynamics 365 Business Central content pack that you want to use, and then select Get it now.
3.When prompted, enter the name of your company in Dynamics 365 Business Central . This is not the display name. The company name can be found on the 'Companies' page within your Dynamics 365 Business Central instance.
4.Once connected, a dashboard, report and dataset will automatically be loaded into your Power BI workspace. When completed, the tiles will update with data from your Dynamics 365 Business Central company.
Hope this helps you.