When you connect your Fenwick Gold for Power BI app to Business Central, you will be asked to authenticate the data source. There are two methods:
OAuth2 Authentication
About OAuth2 authentication with Business Central
- Set the Authentication Method to OAuth2
- Set Privacy level setting for this data source to Organizational
- Click Sign in and connect
Basic Authentication via Web Service Key (LEGACY)
*Basic Authentication is deprecated and no-longer supported by Microsoft-hosted environments.
About Basic Authentication with Business Central
- In Business Central navigate to your user card and find the Web Service Access section. Next to the Web Service Access Key field click the ellipsis button (…) to generate a new Web Service Access Key
- Click the toggle to enable ‘Key Never Expires’ then click OK
- Copy the generated key making sure that you capture the entire key (it will end with an equal sign ‘=’)
- Navigate back to the Power BI Service (https://app.powerbi.com) and click ‘Connect your data‘
- Select Basic as the authentication method
- The Username will be your Business Central User Name. The Password will be the Web Service Access Key you generated for that user
- Click Sign in and connect