I am able to get the OAuth Authorization successful. When I start querying on the datasources, am getting the following error.
SELECT * from CampaignPerformanceReport
Error Message: Couldn't parse ReportScopes connection property. Make sure it is formatted as explained in its documentation.
This is the format of the Report Scope that I have provided in the Datasource connection options:
'Accounts=accountid;Campaigns=campaignid:accountid;';