Forum Discussion
How to get live data from a REST API requiring OAuth 1.0 authentication?
The question pertains to Power Bi Online where I would like to pull data from a REST API which requires OAuth 1.0 authentication, something I cannot find in the gateway settings.
What is your recommended approach to pull data from a REST API requiring OAuth 1.0 authentication live every time a user loads or refreshes the Power Bi report?
6 Replies
UserBUG ,
You are able to use in OAuth 1.0 authentication in Power Query or Power BI Desktop.
https://www.kasperonbi.com/getting-data-into-power-query-with-the-twitter-search-api-how-to-hack-pq-to-use-oauth/
Based on your description, do you want to add the project online data source within on-premises gateway and refresh your dataset in Power BI Service? If that is the case, as you are connecting to online data source(Project Online), gateway is not required to refresh your dataset. Go to Settings->Datasets and find your dataset , you should find that Power BI Service connect directly to your data source, after you edit the credential for your data source, you are able to set schedule refresh for the dataset.
Regards,
LydiaThank you for your feedback, Lydia!
Said approach would require to refresh data continuously through Power Bi Desktop, though.
My intention is to publish the report (via iFrame) to users (without any Power Bi Desktop).
For that purpose, the report needs to be refreshed online whenever a user access it or on a scheduled basis (at least every 15 minutes).
How would I go about it in this case?
UserBUG,
After you publish PBIX file to Power BI Service, you can set schedule refresh for your dataset. To schedule data at least every 15 minutes, you can purchase Power BI premium, otherwise, you are limited to refresh datasets up to 8 times a day.
Regards,
Lydia
