Forum Discussion
REST API Silent Authentication (Token)
Thanks Eric_Zhang, I already solved it,
Just read a little more how the authentication flow works :)
Of course,
When I calmly read the message "The user or administrator has not consented to use the application" I started to ask myself "where could I consent the permissions", the quick response came "Azure AD".
I started to search how the Azure AD permissions system works and I found this link:
Https://docs.microsoft.com/en-us/azure/active-directory/develop/active-directory-integrating-applicationsAfter reading it I conclude: I created the application through PowerBI (http://dev.powerbi.com/apps) which generated an application in Azure AD (http://portal.azure.com), so I still had to delegate the application permissions - my user was also the account administrator so I just needed to grant the permissions.
Steps:
Create app on PowerBI > Go to Azure Portal > Find Azure Active Directory > Find the Application > Grant Permissions
Any questions are welcome.
Please look at below blog post see it helps.
https://zappysys.com/blog/howto-import-json-rest-api-power-bi/
Using ZappySys ODBC API drivers you can import any REST API.
Check below example how to use OAuth connection in ZappySys ODBC driver. You can select Custom Provider + OAuth 2.0 Version. Select Scope, Grant Type (i.e. Password Grant), Client ID, Userid, password.
You can also supply non-standard OAuth attributes on Advanced Tab (e.g. resource=http://your-resource-url)
ZappySys Driver - OAuth Configuration (Grant Type, Scope, Auth URL)
ZappySys ODBC JSON Driver - Configure REST API callZappySys ODBC JSON Driver - SQL Query Preview (Read from JSON / XML / CSV File or REST API