Connecting QuickBooks Online to Power BI via API (OAuth2) - Issue with Refreshing Access Token

[novelmayank]

Hello everyone,

I am attempting to connect QuickBooks Online to Power BI using the API with OAuth2 authentication. I have tried several methods to get the data, including:

• Power BI Web connector
• QuickBooks connector
• Custom connector (this was quite challenging to build, so I might have made some mistakes)
• Python script

Out of these methods, the Python script has been the most successful. However, I'm facing an issue where I need to manually change the access token every time I want to refresh the data.

I've created a function to fetch a new access token, but when I replace the static access token with this function in my data script, it doesn't work. I have also tried implementing this solution in the Web connector, but without any success.

Has anyone encountered a similar issue or could provide guidance on how to automate the access token refresh process within Power BI? Any help or suggestions would be greatly appreciated.

Thank you!

@amitchandak it would be a great help if you could suggest something.

[Anonymous · Accepted solution]

HI @novelmayank,

I'd like to suggest you use web connector to getting data from REST API. You can add a step to getting access token at first, then you can use this token in following steps. (this get token operation will be invoked every time the data source refresh to prevent the expired issue in other steps)

Solved: Pull data from a REST API Authentication - Microsoft Fabric Community

Regards,

Xiaoxin Sheng