To connect Power BI to Xero using the OAuth2 authentication flow, you will need to follow these steps: Open Power BI and click on "Get Data" from the Home tab. Search for "Xero" in the search bar and select the Xero connector. Select the authentication method as "OAuth2" and click on "Connect". In the "Sign in" dialog box, enter the Xero account credentials that you used to create the Xero APP. You will be redirected to the Xero authentication page where you will be prompted to grant permission to the APP to access your Xero data. Grant the permission. Once the permission is granted, you will be redirected back to Power BI and a dialog box will appear, displaying the Xero data entities that you can connect to. Select the desired entity, such as "Profit and Loss", and click on "Load" to import the data into Power BI. If you have already received the bearer token from Xero using Postman, you can use it to connect Power BI to Xero by selecting the "OAuth2" authentication method and entering the bearer token in the "Access token" field in the "Advanced" section of the Xero connector dialog box. If you are still facing issues, make sure that your Xero APP has the required permissions to access the data entities that you are trying to connect to. You can check the permissions by logging into your Xero developer account and reviewing the APP settings.
